SYSTEM FAILURE

Hi everybody,
Can someone let me know how to restore a database after a system failure? Actually I just joined as a DBA and I have never have this experince before.
Thanks

We can definitly show you tons of articles online, but without knowing the scenario our help will be limited.
These are some of the things we like to hear:

1. Can you tell us what backups you take and days?
   • What is the current status of the server and database?
     • When this failure happend?

• • • Without basic understanding of the issue, we may point you to a jungle of articles where you will get lost

Hi Peerthi,
Yes, I should have given more information to you.I am taking full,differential and transaction log backup.This happened yesterday evening.The server is online and the database is also online but we lost some transation when we had that failure. So can you please, guide me through it.
Thanks

Good information. If you have specified dates time of the backups, it would have been easier to explain.
Don't panic. Check whether you have all the backups in hand. Also test whether they are in a good condition. Send a mail to all stakeholders that the database server will be down for some time.(If you can specify the time needed it will be helpfull)
This is the backup procedure.

1. Take a tail log backup. That is a log backup, but leave the database on restoring state. (Check Options tab in the backup dialog box)
   • To be sure, take a copy of the database files. In case of any failure, you may need them.
     • Restore the Last Full backup
       • Restore the last Differential backup (Taken after the full backup) If you haven't taken a differential backup after the last full backup, dont restore anything
         • Restore ALL transaction log backups taken after the last backup(full or differential, whatever is latest) on the order of the date/time.
           • restore the transaction log backup taken at step 1
             • Your restore operation is complete. Test the system.

• • • • • • • If you want to read anything further, Books online will definitly help you.

Hi Peerthi,
I really appreciate you help. Thanks a lot.
Jackson

Pleasure is mine.The primary purpose is sharing the knowledge. We learn by sharing.By looking at your number of posts, I understand, you are quite new to the forum. Welcome to the community!