August 28, 2006 at 1:14 pm
I've been restoring SQL Server 2000 Application DB's (Fulls, Diffs, and Txn Logs) for years.
For an upcoming D/R test I need to Restore the System DBs. (Master, MSDB, and Model)
Can I simply use SQL Server 2000's RESTORE DATABASE syntax for these 3 DB's? Are there any special items to do during the System Restore?
(fyi, my starting point is a SQL Server 2000 Server w/ SQL Server 2000 & sp4 installed)
August 28, 2006 at 2:23 pm
Microsoft has some good articles on this. So does BOL...see the title "Restoring the master Database from a Current Backup"
Below is nice detailed link on a lot of the various backup/restore capabilities of sqlserver.
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx
August 29, 2006 at 1:32 pm
The master is the pestiest, the database has to be in single user mode, so no other processes can be running. Start the instance in single user dbo more. I've used a ISQL script to restore the master from the command line. If you went the Microsoft default installation path's it's a little easier, otherwise you may have to specify path info. After the master the rest of the db's restore like a user database. The one caveat is MSDB. The system pays close attention to the version or release of the MSDB and poses some issues when their is a version mismatch.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply