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 (AT) iba (DOT) org.il> wrote