As you saw in Chapter 3, the
command is simple:
RESTORE DATABASE AdventureWorks
WITH RECOVERY
You don??™t need to specify files to restore or any other options. Just specify the database
name and the WITH RECOVERY clause. Once you do this, the standby database is online,
available for read/write operations and ready to become the new principal database.
CHAPTER 6 n MAINTAINING A WARM STANDBY SERVER VIA LOG SHIPPING 165
nNote Remember, if you fail to specify a WITH clause, the default is to get the WITH RECOVERY behavior.
While restoring transaction logs, be sure to explicitly indicate WITH NO RECOVERY. Once the database goes
through its recovery process, no additional transaction logs can be restored! If this hasn??™t sunk in by now,
go back to Chapter 3 (do not pass Go; do not collect $200).
Step 4: Copy Dependent Items
Copying dependent items is a commonly missed or underestimated step in the failover
process. A number of items could have been added to the primary server after the secondary
server was established??”for example, new database logins or external applications
or services.
Pages:
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323