Can anyone describe the step by step process of recovery via backup and restore in SQL Server 2008.
If possible please include some examples.
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.
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.
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