Today i was playing with SSMS in Denali and found few Very Very Interesting enhancements with Restore Task. Let me show you what i’m saying….
Let’s play with Adventureworks Database for demo purpose. FYI I’ve a folder on my D$ where i placed all my Full, Diff and T-Log backups for this database.
First, let’s see what SQL Server 2008R2SP1 SSMS offers us when we try to do a point in restore on the same instance.
In SSMS go to TASKS and Restore and Database as shown below.
By default it chooses from Database where it automatically picks the Backups(Full/Diff and Log) accordingly what it needs to perform a Restore to most recent possible point in time as shown below.
Perfect, this is awesome….But, what if we choose from device, where we’ve to select our Backup files manually..Let’s see what 2008R2SP1 offers to us.
Ummm…Basically your are missing an option where you can select an entire folder and It automatically picks the required individual backup files as per the LSN’s…..So, we’ve to pick all the individual backup files required manually.
Let’s see Point In Time Restores(Recovery) for SQL 2008R2 SP1:
I’m choosing from Database for ease in demo purposes. I’ve chosen 11.00 AM in the first scenario, and it basically chooses the required as shown below.
This is So Nice…..But again if you’ve to choose from device, you’ve to point to individual Back up files manually(Which is Okay Most of the times, but irritating in few cases..It all depends).
Now, Let’s see what DENALI SSMS can do for us in Restore operations
At the very first glance…..You can see, Now we can do PAGE Restores using SSMS as shown below. Upto 2008R2 we’ve to use T-SQL Commands to Restore a single page.
Note: I was creating a Maintenance Plan for Backups and I found one interesting enhancement where we can select “which account” do you want to run this Plan under( As per the below Image).
In SQL Server 2008R2, we didn’t had this option. We’ve to go to Agent Jobs and change the Job owner and Execution Context. One more interesting thing to note.
Okay..Let’s actually do the Point in time restore from SSMS in Denali. I RC’d on the database which i want to perform a Restore ->Tasks restore -> Database. Let’s see what exactly DENALI is doing for us in this process.