BackUp Exec Skipping SQL Server databases

[SeanB]

Does anyone know why when I am running Backup Exec I am getting Failure and it says all the files under the Data directory are in use - skipped??

 

[tlbroadbent]

As long as SQL Server is running the files are in use and cannot be backed up. You have a few options.

1- Stop SQL server while backing up the server. This is usually not acceptable.
2- Use SQL Server to backup the databases and use Backup Exec to backup the SQL backup files. This is similar to the method we use.
3- Use a backup product with a SQL Server agent that will hook into SQL Server and backup the databases.

Others may have additional recommendations. Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.

 

[SeanB]

Thanks man. That is what I was thinking as well. I appreciate it.