Djabarov, Robert
Robert.Djabarov at usaa.com
Mon Mar 22 08:59:07 CST 2004
I think Martin is referring to SQL Server program files, not data/log/backup devices. Robert Djabarov SQL Server & UDB Sr. SQL Server Administrator Phone: (210) 913-3148 Pager: (210) 753-3148 9800 Fredericksburg Rd. San Antonio, TX 78288 www.usaa.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Francisco H Tapia Sent: Monday, March 15, 2004 11:13 AM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] re: any ideas In your first post you mentioned that they turn off the sqlAgent$filenme and sqlserveragent are both shown as manual, but check the service marked MSSQLSERVER, have them check that it is stopped allong with the agents and then attempt the cold back up at that point. And if it's not to forward, find out why they choose COLD backups over warm backups.. and IIRC, you can't just slap in the mdf/ldf files if a catastrophy where to occur and expect the server to run fine. In a good backup procedure you always have at some point a test to see if your backup plan works. At my site, I run backups regularly but I also do TEST the backups on our local test boxes and also at home. just my 2cents... Martin Reid wrote: >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 > > > > -- -Francisco _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com