If you??™re going
CHAPTER 3 n RESTORING A DATABASE 64
to attempt a page restore, make sure you have a complete list of damaged pages. If you
run into an error during a RESTORE but don??™t have the CONTINUE_ON_ERROR option set, you
may be restoring a single page only to discover more damage than you initially encountered.
Only perform page restores with IDs collected from either a complete DBCC CHECKDB
run or from MSDB..SUSPECT_PAGE.
Restoring System Databases
Many DBAs are familiar with restoring a user database, but what happens if you lose the
entire instance? You had better be familiar with restoring system databases, and master
databases in particular. The other system databases??”MSDB, model, distribution, and
resource (you do know about the resource database, yes?)??”can be equally important,
but the master is your starting point. Always.
Master
Every DBA should practice restoring a master database. The process is unlike any other
database restore.
First, stop the SQL Server service via SQL Server Management Studio, SQL Server
Configuration Manager, or the Services applet in the Control Panel.
Pages:
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158