My Tech Tree 
Branches of knowledge not found just anywhere

                         ^ stuff
 

Server Restore

SQL restore

restore Master first. You have to be in single user mode. Stop sqlserver and sqlagent services, at command prompt run from the MSSQL\binn folder the following:

sqlservr.exe -m

be patient takes a while

once SQL server starts up,,,,,restore your master.mdb

next

restore msdb.db and stop/start sql server

restore all other databases after that

0 Comments