Database Technologies‎ > ‎MSSQL‎ > ‎

Restoring Master DB from backup

Restoring Master Database through backup

Before restoration make sure, the sql server version and the os build are at same level.
After that start the mssql server service in the single user mode.

C:\Program Files\Microsoft SQL Server\~\Binn>sqlservr.exe -c -m

After you execute above, it will show accepting client connections.

Then launch the isql command using the necessary authentication,

isql -E // For OS authentication
isql -Usa // For SQL authentication.

execute , "restore database master from disk='\path\to\master\backupfile\"

 

For SQL 2005
 
Add -m; at the end of the Startup parameters of sqlserver in the Surface area configuration manager
 
Then at command prompt take the session through sqlcmd
 
cmd>SQLCMD
then restore the master database as above
Comments