June 28, 2013 07:38 by Ben
SQL Server 2008 R2 delivers several breakthrough capabilities that will enable your organization to scale database operations with confidence, improve IT and developer efficiency, and enable highly scalable and well managed Business Intelligence on a self-service basis for your users.
This is the tips to restore your database in sql server 2008 :
You need to select the backups which you need to restore from the backup set list.
First, thing to notice here is, it takes a tail-log backup of the source database.
The Backup Sets list does not list all backup sets available in the media, it only lists backups of the selected database:
Also, it is showing only the latest backups since last FULL database backup, just like selecting database as source in earlier versions. Older backup can be restored via "Timeline…", which is self-explanatory:
And to make it complete, it also has a "Verify Backup Media" button. Enjoy it! :)