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.