Post reply

Backup Error: sql-dom sql state 4200

  • January 5, 2004 at 9:54 am

    #83282

    When trying to backup a sql2000 database I receive the following error:

    "Microsoft SQL-DOM (odbc sqlstate: 42000)

    The Volume on device xxx e:\backupfilename.bak belongs to a different media set.

    Backup or restore operation terminating abnormally."

    Thanks for any help,

    Jim

  • January 5, 2004 at 12:10 pm

    #488685

    Is seems you create a media set before with that file. To re use it execute the backup with the FORMAT option.

     

    BACKUP DATABASE DBNAme TO DISK = 'e:\backupfilename.bak' WITH FORMAT

  • January 5, 2004 at 2:56 pm

    #488714

    Thanks racosta - that fixed it.

    Happy New Year

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply