SQL Files not being backed up

[Guest_imported]

NT 4.0 Enterprise SP6
SQL Server 7.0 Enterprise

We are not getting any of our SQL files backed up. We store them in D:/MSSQL7/Data directory. When we run our backup it backups a .ldf and .mdf that reside there from the install but none of our .ldf or .mdf files that we created. It simply returns information that the backup was incomplete and 12 files were not backed up. Any suggestions or help of any kind would be most appreciated.

Thanks,

ASN

 

[wamason]

In order to backup your SQL database you will have to purchase the Arcserve SQL agent. CA can give you a price on the product. The Arcserve SQL agent will allow you to backup these open SQL database files. The other alernative is to use SQL to do a backup to disk(this will create a flat file) and you can use Arcserve to backup this file. In the event of a disaster you will have to restore this file from tape and then use this file to restore the SQL database. The method of choice however is to purchase to Arcserve SQL backup agent as I mentioned earlier. Good luck.