You need to stop it
so you can restart the server in single-user mode.
Start SQL Server in single-user mode. From a command line, type sqlservr ??“m. You
should see startup text in the command window, as shown in Figure 3-8.
Figure 3-8. After you use sqlservr ??“m to open the database, the window remains open until
the instance shuts down.
CHAPTER 3 n RESTORING A DATABASE 65
Restore the master database. Open a database engine query session and issue the
command shown in Figure 3-9. You may receive an error stating that a single session is
already running. Click OK to get past the error.
Figure 3-9. Restoring the master database is only possible when in single-user mode
(sqlservr -m). Any attempt to restore the master while the database is started normally
fails.
SQL Server will shut down automatically if the master restores successfully. Restart
SQL Server normally using SQL Server Management Studio, SQL Server Configuration
Manager, or the Services applet in the Control Panel.
MSDB
SQL Agent activity is the primary source of data contained in MSDB. Job definitions,
schedules, operators, and alerts all make their home in MSDB.
Pages:
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159