Problem with "wrong media sequence number".

• wolfjr

  Say Hey Kid

  Points: 713

  More actions

  May 26, 2002 at 3:14 pm

  #104915

  Hello all,

  I'm using the following script to do one backup:

  -- DB1

  Backup DataBase DB1 to DeviceBackupDAT

  with init, MediaDescription = 'Backup DB 13/06/2001',

  Description = 'DataBase DB1', stats, nounload

  go

  -- DB2

  Backup DataBase DB2 to DeviceBackupDAT

  with noinit, Description = 'DataBase DB2', stats, nounload

  go

  ------------------------------------------

  This has been working, but lately I'm having the error message:

  Server: Msg 3247, Level 16, State 2, Line 3

  The volume on device 'DeviceBackupDAT' has the wrong media sequence number (4). Remove it and insert volume 1.

  This errors occours when I start the execution of script.

  Why he is asking for "media sequence number" ?! May be some problem in script ?!

  Any help, I'll appreciate.

  Thankx.

  WolfJr.

• Antares686

  SSC Guru

  Points: 125444

  More actions

  May 27, 2002 at 3:53 pm

  #429800

  Sounds like the file (I am assuming this is a file device), may have a corruption issue. Try dropping and recreating it and see what happens.

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)