Error on Transaction log backup

[David Greenberg]

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

[Dan Guzman]

Re: Error on Transaction log backup

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.or g.ilwrote in message
news:fq0orp$gu5 $1@news2.netvis ion.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
>
>
>
>