Are you able to perform
a tail-log backup? Can you still copy existing transaction log backups to the secondary
server and restore them to the standby database? Rushing into a restore process
could result in needless data loss.
Step 2: Restore Any Remaining Log Backups
It??™s possible that you still have log backups and perhaps even a tail-log backup that you
can restore. Before applying these log backups, be clear on what the disaster is. If it??™s a
process or user disaster, applying the transaction logs before failing over might just propagate
the same disaster to the secondary server.
nTip Do not recover the database after you restore all of the available logs. Keep that as a separate step.
I??™ve wasted countless time recovering a database before all backups had been restored. Get in the habit of
taking a deep breath, looking around for any stray log backups laying around, restoring those backups into
the proper location, and then recovering the database.
Step 3: Recover the Standby Database
Once you??™re confident that all transaction log backups that can be restored are restored to
the standby server, it??™s time to recover the standby database.
Pages:
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322