So here we go ..first read this small sumamry and then I ahve kept the link to the document that ia hve uplaoded
for using tape Drive... I am not using any third party , No Script, only SQL ENTERPRISE MANAGER
Backup Media
SQL Server databases may be backed up to either a disk or tape media. B
ackup may be performed through SQL Server Enterprise Manager or a Transact-SQL command.
Tape Backups
A database may be backed up to a local tape drive. SQL Server formats the tape backups using Microsoft Tape Format (MTF).
This means that a tape may hold other backups formatted using MTF in conjunction with SQL Server backups.
Tape backups provide certain features that are not available when using disk backups.
1. Continuation media
If the tape to which the backup is being written fills up, SQL Server Enterprise Manager pops a dialog box and prompts for the next tape
(
If using the Transact-SQL command, a message is logged to the SQL Server error log to mount the next tape
and a retry attempt is made roughly every five minutes to see if a new tape was mounted
).
But we can use enterprise manager safely for this
This is in contrast to disk backups, where inadequate disk space terminates the backup operation.
2. Restart option
If there is a power failure or the server shuts down unexpectedly while the backup/restore is being performed, the operation may be restarted from the point at which it was interrupted.
Backing Up Databases
Even though backing up a simple database is easy, rarely are things in their simplest form.
One of the primary variables that will affect your backup is the size of the database. Obviously, a bigger database means a longer, larger backup. If a database is quite large, it may not fit on a single tape or one drive location.
This lengthier backup may also take more time than available to complete the backup.
To deal with these issues, SQL Server 2000 provides the ability to stripe backups
across multiple tapes or disk devices,
so that several devices can be combined to deal with the size and time factors
So I am listing a simple Article here which we can use to backup interactively the SQL Bak file into tape drives which run out of space.
http://groups.yahoo.com/group/sqlcon/files/SQLAdmin/
More over I further recommend reading following articels if the above solution doesnt work
http://www1.us.dell.com/content/topics/global.aspx/power/en/ps4q00_martin?c=us&cs=555&l=en&s=biz
http://www.cryer.co.uk/brian/sqlserver/howtofullw2ksql2000bkp.htm
http://www1.us.dell.com/content/topics/global.aspx/power/en/ps4q00_martin?c=us&cs=555&l=en&s=biz