BISQL #96 – SQL Server 2012 – Restore Database Features and Simplicity
Hi friends
I Just restored database Adventure works DB using SQL server 2012 , i found its more simpler and more informative and clearer than what we have in earlier version.
Already we are talking lot about SQL Server 2012 ,I am always thinking of this release that it is so powerful and so enriched with lots of must required features , My mind couldn’t stop me for posting about it .If you have missed any post on same then links are as follows ..
- BISQL # 95 – SQL Server 2012–What’s new Or Summary for future SQL server
- Developer Experience #1 – What’s new in SSIS ! No More NEW from Now !!
- Breakthrough Insight SQL Server 2012 , SQL Server Evolution 2000 – 2012
- New Features , SSDT Introduction and links
- Installation, Problem, Support and Help !
- Migrating to SQL Server 2012 Failover Clustering and Availability Groups
Following are key feature we can Discuss & observed in SQL server 2012-Restoration
- Source & Destination
- Easy Interface and additional Search Option
- Ease of use in Relocating and Replacing file
- More Info ,Verify Back Media and TimeLine
- Hiding unnecessary and Very clear information
- Attractive Restoring Progress Bar
- Database Auto refresh and fast
Lets see how this features are look like while resorting Database
Source & Destination
Easy separation at first glance for Source and destination
Easy Interface and additional Search Option
Interface adaptability and we can search required file , I always think of this feature when its not there but now i am more happy !
More Info ,Verify Back Media and TimeLine
We have more crystal clear information wile restring back up with verify backup media and timeline option
Ease of use in Relocating and Replacing file
We can see in SQL server 2012 more enhanced option for relocating files.
Hiding unnecessary and Very clear information
Attractive Restoring Progress Bar
Ohhh !! is it ! Yes progress bar what we love always its there and more comprehensive and fast as also shown in following screen shot
Database Auto refresh and fast
We will have more post related to restoring and all on next post on SQL Server 2012
You may also interested in reading topics like
- MSBI #45 – SQL Server 2012 #1 – Now SQL Server ‘Denali’ is 2012 !
- BISQL # 51 : SQL Server Denali Feature # 2 – Sequence number –All Explanation !!
- BISQL # 53 : SQL Server Denali Feature # 3 – Always On (Concept ,Architecture)
- BISQL # 50 : SQL Server Denali Feature # 1- File Tables # 2 – Demo and Scripting
- BISQL # 49 : SQL Server Denali Feature # 1–File Tables #1 – Introduction & Theory
Hope you will like this post on Restore Database.
If you really like reading my blog and understood at least few thing then please don’t forget to subscribe my blog.
If you want daily link and analysis or interesting link go to following website which will give @ your inbox please subscribe our following link resource blog :
For More information related to BI World visit my Mentalist Blog
Link Resource Blog >> Daily Interesting links
SQL Server Mentalist >> SQL Learning Blog
Business Intelligence Mentalist >> BI World
Connect With me on
| Facebook |Twitter | LinkedIn| Google+ | Word Press | RSS |
SQL Server Mentalist 
Very nice article. 2012 is easier than previous version but I wonder how long it will take Microsoft to rename “device” to “backup file”?
Progress bar seems to be more reliable but it is will be more confusing! progress on the left, progress at the top!
Yes True ! Thanx for stoping on my blog really glad you like it !!