Home » SQL Server » How to restore Master database – SQL Server System Database?

How to restore Master database – SQL Server System Database?


Steps to restore SQL Server Master Database :-

1) Stop SQL Server Services

2) Add [-m] startup parameter in SQL Services from configuration manager

Parameter [-m] Starts SQL Server instance in single-user mode. SQL Server in single-user mode can connect with single user only and did not start CHECKPOINT process. Starting SQL Server in single-user mode enables any member of the computer’s local Administrators group to connect to the instance of SQL Server as a member of the sysadmin fixed server role.

From SQL Server 2005 to 2008 R2

From SQL Server 2012

3) Start SQL Services & SQL server will come online in single user mode. Connect using SQLCMD

4) Execute Restore command

RESTORE DATABASE MASTER FROM DISK = ‘C:MASTER.BAK’;

Message :

Processed 352 pages for database ‘MASTER’, file ‘master’ on file 1.

Processed 2 pages for database ‘MASTER’, file ‘mastlog’ on file 1.

The master database has been successfully restored. Shutting down SQL Server.

SQL Server is terminating this process.

5) After Master DB restore, You SQL services will be shutdown. Start SQL Services in normal mode by removing [-m] parameter.

6) You are done !

Reference : Rohit Garg (http://mssqlfun.com/)

You can find and follow MSSQLFUN :-

http://www.facebook.com/mssqlfun

http://mssqlfun.com/feed

https://twitter.com/Rgarg86

Other Linked Profiles :-

http://www.sqlservercentral.com/blogs/mssqlfun/

http://social.msdn.microsoft.com/Profile/rohitgarg

http://www.toadworld.com/members/rohit-garg/blogs/default.aspx

http://beyondrelational.com/members/RohitGarg/default.aspx

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: