Restoring the SQL Server System library

Restoring the SQL Server System library

Total three system libraries to restore, restore sequence: Master>msdb>model

1. Restore Master

(1). After you add "-M" to the startup parameter, database service properties, database Configuration Manager, restart the SQL service and the database enters single-user mode.

(2). Open the Database administration tool

(3). Pop Up the Connection service window and click "Cancel"

(4). Click "New Query", then log in as Windows, the user name must be administrator

(5). Restore the Master System library by executing a RESTORE statement inside the window

Method Two: The way the Command window operates:

　　2. Restore msdb

(1). Cancel the single-user mode, delete "-M" After you restart the SQL service, stop the SQL Agent service

(2). Open SSMs window, log in with Administrator account, execute RESTORE statement

(3). Start the SQL Server Agent service to see the jobs

Method Two: How to operate the command window (be sure to stop the SQL Agent service first)

3. Restore model (general model changes little, no need to restore)

Yang Zhengjiang June 20, 2017

I small white, if there is the wrong place, but also hope you point out!

Original path: http://blog.csdn.net/kk185800961/article/details/41920923

Restoring the SQL Server System library