BE SQL Agent Error

[skippaNH]

Hi,

BE Version 9 is backing up several SQL Server 2000 databases. It is failing on one database. The error being returned is "unable to open item TFO.mdf - File is in use."
This error is returned even when I show no cursors attached to the database.



Thanks in advance.

 

[SQLBill]

Are all the SQL databases on one server? Or is TMO on it's own server?

-SQLBill

 

[skippaNH]

TFO is on the same server as other databases that are being backed up. I just created another db and restored a backup of TFO into it. BE was able to backup the restored db fine.