Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

My Experiments with SQLServer
Browse by Tags · View All
SQLServer 126
SQLServer 2008 R2 91
SQLServer 2008 86
SQLServer 2005 82
SQL 60
Database 59
Sql And Me 57
Tips & Tricks 28
SQL Server 27
SQL FAQ 26

Archive · View All
May 2011 25
June 2011 21
July 2011 21
August 2011 19
April 2011 16
January 2013 4
May 2012 3
April 2012 3
October 2011 3
February 2013 2

Vishal Gajjar's Blog

SQL Server – Denali – Management Studio – Restore Database

Jul 19 2011 8:19AM by Vishal Gajjar   

In Management Studio 2008 R2, restore database dialog is as below:

Management Studio 2008 R2

You need to select the backups which you need to restore from the backup set list. This dialog box is tweaked in "Denali":

Management Studio "Denali"

First, thing to notice here is, it takes a tail-log backup of the source database. In earlier version, we needed to *remember* to do the same before restoring the 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.

Hope This Helps! Cheers!


Republished from Sql&Me [31 clicks].  Read the original version here [32134 clicks].

Vishal Gajjar
46 · 4% · 1276
0
Liked
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

Your Comment


Sign Up or Login to post a comment.

    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]