Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Problem backing up Transaction logs within EM

Author  Topic 

Yak Posting Veteran

98 Posts

Posted - 2006-12-23 : 17:44:23
Not sure what happened, but I came back from vacation and was doing some manual backups.

I was using EM with no problem.
I first backed up the database with the Wizard. Did a full backup and put it on the local share.

Next, I went to backup the T-Logs using the wizard and was going to back it up on the local disk as well.

However, I get a errors. A box pops up and says:

The volume on device D:\Backup share\<name of DB backup> is not part of a multiple family media set. BACKUP WITH FORMAT can be used to form a new media set.
BACKUP LOG is terminating abnormally

Any ideas?


Posting Yak Master

145 Posts

Posted - 2006-12-24 : 01:16:59
May be your backup file is part of stripped backup set...
Use FORMAT option or delete the file before running the backup...

Go to Top of Page

- Advertisement -