recover from backup to N backup devices

09-10-08, 02:19 AM

GPO

We currently use this code to backup our database:
BACKUP DATABASE [my_db] TO
DISK = N'E:\SQL Backups\my_db_Backup.bak',
DISK = N'F:\SQL Backups\my_db_Backup.bak'
WITH
NOFORMAT,
INIT,
NAME = N'my_db-Full Database Backup',
SKIP,
NOREWIND,
NOUNLOAD,
STATS = 10
GO

When I try to restore from just one of the files I get this message:
"The media set has 2 media families but only 1 are provided. All members
must be provided."
My question is this: If the E:\ drive or the F:\ drive dies and we lose
access to one of the members do we lose access to the entire backup?

This would be ironic because I think the person who set it up, did it across
two drives precisely to avoid this outcome.

09-10-08, 02:35 AM

Dan Guzman

> My question is this: If the E:\ drive or the F:\ drive dies and we lose
> access to one of the members do we lose access to the entire backup?
>
> This would be ironic because I think the person who set it up, did it
> across
> two drives precisely to avoid this outcome.

The purpose of a striped backup is for performance, not redundancy. If you
need redundancy, specify MIRROR TO or make a copy the backup files
afterward.

Similar Threads
Vista Backup problem: Looking for backup devices Hello there, I've created a Windows Complete PC Backup of my new laptop. Now a few days later I want to actualize it, but when click on Back up computer in Backup and Restore...
Vista Complete Backup could not find backup devices I'm trying to create a complete PC backup on Vista Ultimate. I'm using an external USB harddrive NTFS formatted. I have already backup once, as noted by the "Last backup:"...
Too many backup devices specified for backup or restore; Only 64 are allowed. RESTORE DATABASE is terminating abnormally On my developer machineI have SQL server 2005 express with a database configured as sql server 2000 compatability. I back the database up and copy it to a second server...
Backup hangs on "looking for backup devices" I've successfully backed up my Pc, (to a file on the desktop) once before. However now when I start backup it hangs on the monlogue box "looking for backup devices" and goes...
Backup devices and backup expire We have a third party application that backs up a sql server database as part of its overall backup plan. This is hardwired into the application, so that it must have a...