This mode gives
you yet another option for dealing with a database in SUSPECT status. Essentially, starting
a database in emergency mode tells SQL Server to bring the server to an online status
without attempting the recovery process. The database then remains in its damaged
state.
While the database is still technically in its damaged state, you can at least detach it
or extract the data from the database. However, you cannot guarantee the transactional
consistency of the database.
Technically, the emergency mode feature did exist in previous versions of SQL Server,
but you were forced to manually alter a system table in the master database in order to
put a database into that mode. I??™ve had the unfortunate pleasure of dealing with databases
so damaged that starting in emergency mode was the only option; in every case,
the reason it was the only option was because something was missed in the design of
CHAPTER 3 n RESTORING A DATABASE 71
the backup and recovery scheme. Emergency mode should be a sign not only that there??™s
a problem with your database, but that there??™s a problem with your process as well.
Pages:
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169