While I was trying to restore the backup of master database taken in SQL Server 2008 on to an SQL Server 2008 R2 instance, I was presented with the below error.
|Msg 3168, Level 16, State 1, Line 1 The backup of the system database on the device D:\Backup\master.bak cannot be restored because it was created by a different version of the server (10.00.1600) than this server (10.50.1600). Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally.|
Using the below commands, we can verify if the build versions of both the instances are same or different.
--To get the current Instance version SELECT @@SERVERNAME AS ServerName, SERVERPROPERTY('ProductVersion') as CurrentSystemVersion --To get the version of instance where backup is generated --Look at the columns "SoftwareVersionMajor", "SoftwareVersionMinor", "SoftwareVersionBuild" RESTORE HEADERONLY FROM DISK = 'D:\Backup\master.bak'
More information at http://support.microsoft.com/kb/264474