Option to restore all backups (files) within a media set - by Greg Low - Australia

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


11
0
Sign in
to vote
ID 769204 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 10/30/2012 4:37:51 PM
Access Restriction Public

Description

The default action when performing a backup is to append to the backup file.

The default action when restoring a backup is to restore just the first file.

I constantly come across customer situations where they are puzzled that they seem to have lost data after they have completed a restore. Invariably, it's just that they haven't restored all the backups contained within a single OS file. This happens most commonly with log backups but also happens when they have not restored the most recent database backup file.

It is not trivial to achieve this within simple T-SQL scripts, when the number of backup files within the OS file is unknown. It really should be.
Sign in to post a comment.
Posted by Microsoft on 2/6/2013 at 10:35 AM
Unfortunately, there are many circumstances where this would be the wrong thing to do. Customers who put multiple backups in a single file may mix backups from multiple databases, etc. There's no way for us to know what the real desire is.
What I find more common is for customers to embed a date/time string in the filename. This gives a unique file for each backup, and facilitates sequencing. Added to the recovery manager in SQL Server 2012, the restore process gets very simple.
Posted by Microsoft on 2/6/2013 at 10:34 AM
Unfortunately, there are many circumstances where this would be the wrong thing to do. Customers who put multiple backups in a single file may mix backups from multiple databases, etc. There's no way for us to know what the real desire is.
What I find more common is for customers to embed a date/time string in the filename. This gives a unique file for each backup, and facilitates sequencing. Added to the recovery manager in SQL Server 2012, the restore process gets very simple.