Tuesday, February 14, 2012

Backup

Hi
I am having problem with schedule tape backup in maintenance plan sql server
2005<o:p></o:p>
I have made a schedule for tape backup on Ultrium 2 LTO drive for all
databases. Backup succesfully completes but the tape could not be unloaded
even after pressing the eject button on the tape drive. I could not find any
tape unload/rewind option in the maintenace plan.<o:p></o:p>
Is there any option avilable in sql server 2005 to unload the tape in the
maintenance plan schedule backup, if so pls let me know the same at your
earliest and that will be a great help for me<o:p></o:p>
Thanks with regards
VijayHi
"Vijay" wrote:

> Hi
> I am having problem with schedule tape backup in maintenance plan sql serv
er
> 2005<o:p></o:p>
> I have made a schedule for tape backup on Ultrium 2 LTO drive for all
> databases. Backup succesfully completes but the tape could not be unloaded
> even after pressing the eject button on the tape drive. I could not find a
ny
> tape unload/rewind option in the maintenace plan.<o:p></o:p>
> Is there any option avilable in sql server 2005 to unload the tape in the
> maintenance plan schedule backup, if so pls let me know the same at your
> earliest and that will be a great help for me<o:p></o:p>
> Thanks with regards
> Vijay
>
I don't know of any option, but you could add a job step that did a RESTORE
REWINDONLY at the end of the job. See Books inline for more.
John

No comments:

Post a Comment