Backup SQL Server 1

[technical1]

I have a question regarding backing up SQL 2000 databases.
I back my database every night at 2am using sql server enterprise manager. I also back my transaction logs to disk every 1 hour.

My question is, if im already writing the backups to disk then using BrightStor and a Windows remote agent couldnt i back up the database and transaction logs to tape.

Thus not requiring a SQL Server agent?

Regards,
Vinay

 

[ajtmcse]

The purpose of the application/database agents is to allow your application to keep running while giving you the ability to backup the application reliably, and keep disk use to a minimum.

By using the SQL built in backup or export commands and then backing those up at the file level, you are just as safe as using the agents, just taking up more disk space than if you were using the agents.