Backup to tape with SQL and NTbackup

We want to use the SQL 2000 backup to tape capability to
backup databases directly to tape, but also allow
NTBackup (from Windows 2000 or Server 2003) to write to
the tape without over-writing the SQL data.
I know that I can use SQL backup to write the backups to
disk, but I cannot afford the disk space, as tapes are
far cheaper than disks...
Does SQL backup recognise that NTBackup data is written
to the tape? Or does NTBackup recognise a previous
session from SQL and then append?
If one recognises the other, then I can simply set the
timing to ensure that the more "stupid" of the backup
routines runs first...
Any help appreciated.Beginning with SQL 7 ( I beleive it was), the SQL group changed the SQL tape
backup format to match that of the OS backups, so they are now compatible,
you may put both on the same tape... (Just be sure to append, not
overwrite.)
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
<myname@.discussions.microsoft.com> wrote in message
news:026801c3cdfb$aca4e940$a001280a@.phx.gbl...
> We want to use the SQL 2000 backup to tape capability to
> backup databases directly to tape, but also allow
> NTBackup (from Windows 2000 or Server 2003) to write to
> the tape without over-writing the SQL data.
> I know that I can use SQL backup to write the backups to
> disk, but I cannot afford the disk space, as tapes are
> far cheaper than disks...
> Does SQL backup recognise that NTBackup data is written
> to the tape? Or does NTBackup recognise a previous
> session from SQL and then append?
> If one recognises the other, then I can simply set the
> timing to ensure that the more "stupid" of the backup
> routines runs first...
> Any help appreciated.