Backing up SQL 2000 database error

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.
regsampAsked:
Who is Participating?
 
epichero22Connect With a Mentor Commented:
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
 
regsampAuthor Commented:
That was it. Thank you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.