I wonder if anyone can help me with the following error message.

We use Sql 2000.

I wanted to backup the transaction log of a database with this command:

BACKUP LOG [testdb] TO [TestdbBCK] WITH NOINIT , NOUNLOAD ,
NAME = N'TestDB backup', NOSKIP , STATS = 10, NOFORMAT

and I got the following error message:

Server: Msg 3132, Level 16, State 1, Line 1
The media set for database 'testdb' has 2 family members but only 1 are
provided. All members must be provided.

I know who MY family members are but I never knew that my databases have
family members !!!

Can anyone help me with this error ?

Thanks !!

David Greenberg

Backups can be striped among multiple devices (files/tables). My guess is
that a striped backup was previously done that included TestdbBCK so
subsequent backups to that device need to be striped as well.

To overwrite with a non-striped backup, specify both INIT and FORMAT.

--
Hope this helps.

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

"David Greenberg" <davidgr@iba.org.il> wrote in message
news:fq0orp$gu5$1@news2.netvision.net.il...
>I wonder if anyone can help me with the following error message.
>
> We use Sql 2000.
>
> I wanted to backup the transaction log of a database with this command:
>
> BACKUP LOG [testdb] TO [TestdbBCK] WITH NOINIT , NOUNLOAD , NAME =
> N'TestDB backup', NOSKIP , STATS = 10, NOFORMAT
>
> and I got the following error message:
>
> Server: Msg 3132, Level 16, State 1, Line 1
> The media set for database 'testdb' has 2 family members but only 1 are
> provided. All members must be provided.
>
> I know who MY family members are but I never knew that my databases have
> family members !!!
>
> Can anyone help me with this error ?
>
> Thanks !!
>
> David Greenberg
>
>
>
>