Ejecting Tape automatically after Backup

I had configured a Database Maintenance task for performing daily full
database backup into tape drive and it is working fine.
My problem is after performing the backup it is not ejecting the tape out of
the drive automatically. Also there is no option available in the Database
Maintenace Wizard to configure same.
Can any body help me?
Thanks
Satyaki
satyaki wrote:
> I had configured a Database Maintenance task for performing daily full
> database backup into tape drive and it is working fine.
> My problem is after performing the backup it is not ejecting the tape out of
> the drive automatically. Also there is no option available in the Database
> Maintenace Wizard to configure same.
> Can any body help me?
> Thanks
> Satyaki
Just a suggestion, we leave the tapes in the drive as it shows that the
tape did not run out of space. When a tape is full, it ejects so you
can put another in - and the person changing the tapes immediately knows
something is wrong.
|||We have got tape for all week days and database size is not big enough to be
full.
Problem is that SQL server is in a differnt location where there is no
skilled person available. They generally forgot to remove the tape at night
time shutdown or replacing it next day.
Thats why I am asking this.
"Ian" wrote:

> satyaki wrote:
> Just a suggestion, we leave the tapes in the drive as it shows that the
> tape did not run out of space. When a tape is full, it ejects so you
> can put another in - and the person changing the tapes immediately knows
> something is wrong.
>
|||Have to script. The maintenance wizard does not provide an interface for
the full statement.
Check out:
http://msdn.microsoft.com/library/en...asp?frame=true
WITH UNLOAD is the option you want.
Sincerely,
Anthony Thomas
"satyaki" <satyaki@.discussions.microsoft.com> wrote in message
news:114A011E-EC7C-4874-A895-827FC312B648@.microsoft.com...
> We have got tape for all week days and database size is not big enough to
be
> full.
> Problem is that SQL server is in a differnt location where there is no
> skilled person available. They generally forgot to remove the tape at
night[vbcol=seagreen]
> time shutdown or replacing it next day.
> Thats why I am asking this.
> "Ian" wrote:
out of[vbcol=seagreen]
Database[vbcol=seagreen]