[dba-SQLServer] re: any ideas

Francisco H Tapia my.lists at verizon.net
Mon Mar 15 10:17:19 CST 2004

IMHO, sql server backups are best, but to each their own... in any case 
you are mentioning only the agent name but not the SQLSERVER service.


Martin Reid wrote:

>Any ideas, a question from a friend of mine re using a third party backup
>utility on the  PC.
>Here's the question: When I am NOT working on SQL, and the SQL Service
>Manager says that the Service is not started, Second Copy still reports
>"File in Use" for all of the files in the SQL Server. That means that they
>are not being backed up. Looking at the Services in Windows, I see that
>SQLAgent$FILENAME and SQLSERVERAGENT are both shown as Startup Type: Manual
>and Status: Not Started (blank). So if SQL is not started, what is tying up
>the files? I would like to keep them backed up.

More information about the dba-SQLServer mailing list