Click here to Skip to main content
16,020,261 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Dear all,

Right now restored the MASTER DB of MS SQL server, but once it is restored and I start the instance, it said some signature is not correct.

and if I start that single user mode to restore the master DB again I see it keep try to mount all user database and later on it can't find all, then the single use mode fails.

is the correct order to restore all DBs is:
1) user database.
2) msdb
3) model
4) master DB?
Posted
Updated 29-Apr-15 1:48am
v3
Comments
John C Rayan 29-Apr-15 7:53am    
Did you try the reverse order? 4-3-2-1

1 solution

yeah, some script help to migration password.

It does migrate the password under normal circumstances. I know having done MS Dynamics GP disaster recovery tests that it doesn't work. But on all the rest it was just fine.

the migration of MSDB already do this, why recreate it ?

The name change from Server1 to Server2 will force you to touch every single job to maybe get them to work again. And that isn't guaranteed.

so in your steps, still don;t worry about the resource DB and simply ignore it, right?

The resource DB is for use of the sqlservr.exe only. You never touch it directly. So it is not for anyone to touch at all.

Try to look here: http://www.reddit.com/r/microsoft/comments/2bhntz/how_to_open_corrupted_mdf_file/
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900