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:

Fatal Error when clicking on Services and Applications in Computer Management

This error came about when upgrading to MS SQL 2005 on a Windows 2003 SBS R2 Server from MS SQL 2000 on SBS 2003. During the process of upgrading we encountered a blocking condition which made us fully uninstall all instances of MS SQL 2000 Standard and the 2005 Desktop Engine.

To get this error we need to go to Computer Management and click on Services and Applications.

—————————
Fatal Error
—————————
Execution cannot continue as the language dependent resource file C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\3081\sqlmmc.RLL could not be loaded.
—————————
OK
—————————

After clicking on the OK button it appears that everything works correctly but it’s still annoying for the client and myself.
To get rid of this error I found a copy of sqlmmc.dll in the folder “C:\Program Files\Microsoft SQL Server\80\Tools\Binn” and copied it to C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\3081\ (I had to create the 3081 folder) and renamed the file extension to .rll.

The error has now disappeared.