[dba-SQLServer] re: any ideas

I'm not sure about that part, but I'm with Francisco on this one.
Schedule some SQL backups at frequency to suit, and then have the
friend's backup software backup the backup directory, not the data
directory.

At ETS I scheduled 4 backups a day and never had to bring down the
server to do so, and they were remarkably quick.

Arthur

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Martin
Reid
Sent: Monday, March 15, 2004 8:21 AM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] re: any ideas


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

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com