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.

> 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.

--
Hope this s.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

"GPO" <GPO@discussions.microsoft.com> wrote in message
news:22843EF9-F402-4C11-812F-C08B060B96BF@microsoft.com...
> 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.