Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Can anyone describe the step by step process of recovery via backup and restore in SQL Server 2008.

If possible please include some examples.

share|improve this question

Follow the links:

1.Backup Under the Full Recovery Model

2.BACKUP and RESTORE Commands

3.Back Up and Restore of SQL Server Databases

Hope this will help.

share|improve this answer
thanks Chauhan. – Anto Aug 10 '12 at 10:13

When the database is restored the pages are read from the backup file and written to the correct location in the new physical database file. Any transactions which were within the transaction log are then read from the backup file and applied to the database file or rolled back. When that is done the database is either brought online or left offline so that other backups can be restored.

When backups are taken the same process is used. All the pages which are within the database file are written to the backup file. Any transactions within the transaction log are then backed up into the file as well.

share|improve this answer
Thanks mrdenny.Can you please explain with a simple example ? – Anto Aug 10 '12 at 8:36
That was the simple example. The only other basic information is that you use the BACKUP DATABASE and RESTORE DATABASE statements. – mrdenny Aug 10 '12 at 8:40
Ok thanks buddy..will try it. – Anto Aug 10 '12 at 8:41

You can take a look at this video: - Backup & Restore Step-By-Step part 1

Hope it will help

share|improve this answer
it helped ...thanks – Anto Aug 13 '12 at 4:37

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.