[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.


-- 
-Francisco

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.
>
>Martin
>
>
>  
>




More information about the dba-SQLServer mailing list