It is always recomemded to document the steps in disater recovery scenarios.
Below are the steps to restore master db in sql 2005 server
Step 1: Stop the SQL SERVICES
Step 2:Enter Command Prompt
Step 3: Go to the path where sqlservr.exe resides.[ default it will be available in : Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn]
Step 4: Execute below query to take the instance into Single User Mode.
sqlservr -c -m
Step 5: Goto MangementStudio-->Cilck on New Query Tab-->Execute Below Query.
RESTORE DATABASE MASTER FROM DISK = '.BAK FILE PATH' WITH REPLACE
Output:
The master database has been successfully restored. Shutting down SQL Server.
SQL Server is terminating this process.
Step 6: Start the services
No comments:
Post a Comment