Find SQL Server Version Information from a SQL Backup

You will need to open up SQL Management Studio and create a new query window:

Type the following command replacing your path, and clicking Execute as shown

RESTORE HEADERONLY
FROM DISK = N’c:\temp\DBBkup.bak’
WITH NOUNLOAD;

The results at the bottom should show a tonne of information about the backup. What your most interested in is the values for SoftwareVersionMajor and SoftwareVersionMinor. The below can be used to identify your version:

Agent XPs component is turned off

In Microsoft SQL Server Management Studio you get the following errors when trying to create a management plan either through the “Maintenance Plan Wizard” or the “New Maintenance Plan…” on an SQL Server 2008.

Cannot show requested dialog. Additional information: unable to execute requested command. ‘Agent XPs’ component is turned off as part of the security configuration for this server. A system administrator can enable the use of ‘Agent XPs’ by using sp_configure.

To fix this right click on the server and select “New Query” as shown.

In the query window on the right type the following:

sp_configure ‘show advanced options’, 1;

GO

RECONFIGURE;

GO

sp_configure ‘Agent XPs’, 1;

GO

RECONFIGURE

GO

Then click Execute as shown.