SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Problem backing up Transaction logs within EM
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

thecoffeeguy
Yak Posting Veteran

USA
98 Posts

Posted - 12/23/2006 :  17:44:23  Show Profile  Reply with Quote
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?

Thanks.

MohammedU
Posting Yak Master

USA
145 Posts

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


MohammedU
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.36 seconds. Powered By: Snitz Forums 2000