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