Home > Backup & Recovery, Management Studio, SQLServer, SQLServer 2012 > SQL Server – Denali – Management Studio – Restore Database

SQL Server – Denali – Management Studio – Restore Database

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

image

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":

image

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:

image

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:

image

And to make it complete, it also has a "Verify Backup Media" button. 🙂

Hope This Helps!

Vishal

If you like this post, do like my Facebook Page -> SqlAndMe
EMail me your questions -> Vishal@SqlAndMe.com
Follow me on Twitter -> @SqlAndMe

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: