Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
ProEdge
Yak Posting Veteran
64 Posts |
Posted - 2007-03-09 : 14:52:57
|
I had to restore my master database a few months ago to another server. The process was painful but I managed to pull it off. I forgot to write down the process and I now I'm sort of stuck again. The problem I'm having is that after I restore, my master database is still referencing the model, msdb databases that were in previous different directories. Since it can't find them, the service fails to start. I remember that I got around this somehow by using a specific startup parameter through the command prompt. I initially shutdown the service and restart it like this:sqlservr.exe -f -m -T3608I add the trace flag so that only the master database is recovered. I then simply restore the master through the GUI, forcing an overwrite. I remember this worked but I'm obviously missing something here. Anyone know a way around this? |
|
rlaubert
Yak Posting Veteran
96 Posts |
Posted - 2007-03-13 : 08:04:49
|
Start with restoring the master from the CD not another database. This will create a clean master to which you can restore from backup (you do have a backup of master, correct). If you don't have a backup of Master you can use the store procedure sp_attachdb to reattach the databases on the server. Unfortunately, without a backup, the users, replication, log shipping, maintenance jobs etc will have to be recreated. You may be able to script these from a 'like' server.Raymond LaubertMCDBA, MCITP:Administration, MCT |
|
|
|
|
|