Solved

Backing up SQL 2000 database error

Posted on 2014-03-11
2
451 Views
Last Modified: 2014-03-11
In Enterprise Manager, when we are trying to backup our SQL 2000 database into a .bak file, we are getting the error message:

"The volume on device C:\backup\database is not part of a multiple family media set. BACKUP WITH FORMAT can be used to form a new media set. BACKUP DATABASE is terminating abnormally."

We need to backup this up so we can eventually move it to a new SQL version on another server. Any assistance offered would be appreciated.
0
Comment
Question by:regsamp
2 Comments
 
LVL 11

Accepted Solution

by:
epichero22 earned 500 total points
Comment Utility
I looked this up and it seems that users with similar problems have had to back up to a new media set.  Of course, make sure you have enough space on your hard drive as well:

Use WITH FORMAT clause or Options - Back up to a new media set and erase all existing backup sets option in the GUI.
0
 

Author Comment

by:regsamp
Comment Utility
That was it. Thank you!
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now