Take the 2-minute tour ×
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. It's 100% free, no registration required.

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

3 Answers 3

Follow the links:

1.Backup Under the Full Recovery Model

http://msdn.microsoft.com/en-us/library/ms190217%28v=SQL.100%29.aspx

2.BACKUP and RESTORE Commands

http://msdn.microsoft.com/en-us/library/ff848768

3.Back Up and Restore of SQL Server Databases

http://msdn.microsoft.com/en-us/library/ms187048%28v=sql.100%29.aspx

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: http://www.youtube.com/watch?v=9U7QxPsA0tw&feature=related - 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

 
discard

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.