[dba-SQLServer] re: any ideas

Martin Reid mwp.reid at qub.ac.uk
Mon Mar 15 10:21:11 CST 2004


I agree but its not one of mine. Tehy back up a couple of PCs in this manner
then take that backup to removable HDD.

Do you think the SQLService is therefore running when they do this?

Martin

----- Original Message ----- 
From: "Francisco H Tapia" <my.lists at verizon.net>
To: <dba-SQLServer at databaseadvisors.com>
Sent: Monday, March 15, 2004 4:17 PM
Subject: [dba-SQLServer] re: any ideas


> 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
> >
> >
> >
> >
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>




More information about the dba-SQLServer mailing list