Eject tape after backups from maintenance plan

• Jim Dillon-291542

  Hall of Fame

  Points: 3344

  More actions

  October 6, 2006 at 7:48 am

  #114722

  Hello,

  I am trying to figure out how to eject a tape after a maintenance plan that backs up 8 data bases. I understand that I need to use the commmands REWIND and UNLOAD, but I can't get to the T-SQL for the maintenace plan to change those two commands. Also, I've tried searching for sample maintenance plan scripts on the internet so I could write the whole thing myself, but I can't seem to find any for maintenace plans that execute backups to tape. Should I scrap the Maintenace Plan and just go for SS Agent jobs?

  Thanks in advance for your time and energy,

  jim

• EugeneZ-162636

  Default port

  Points: 1448

  More actions

  October 6, 2006 at 3:27 pm

  #664689

   To have the tape ejected at the end of the script, add ', UNLOAD'

  e.g.

  BACKUP DATABASE yourDB TO TAPE='\\.\TAPE0' WITH NAME='yourDB COMPLETE', UNLOAD