August 9, 2002 at 3:10 pm
I would like to restore the master database from another MS SQL Server 2000 database. Both servers are MS SQL Server 2000 databases and both setups are identical. I had backup the master database from one server and restored it on another server without any problems until today. I tried the test on the same set of servers today and I received this message:
Server: Msg 3168, Level 16, State 1, Line 1
The backup of the system database on device D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\Test\master_data.bak cannot be restored because it was created by a different version of the server (134218262) than this server (134218383).
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
I believe the problem is related to some patches that I added to both servers. I would like to know if there is a way I can tell what version the sql server is? I know that if I use query analyzer and type this sql line: select @@version, a version number will appear. The only problem is that is does not display the version number as in the above error line. Can someone inform me of a method to display version numbers as in the error line above? Also, is there a way to determine what patches have been installed? It may be possible for me to locate the patch that changed the version number. Thanks.
August 9, 2002 at 3:24 pm
You can look at the MS Baseline Security Tool (http://www.sqlservercentral.com/columnists/sjones/reviewmicrosoftbaselinesecurityanalyzer.asp), but it has bugs.
There isn't a good patch manager for SQL. Hopefully one will get built soon.
Steve Jones
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply