[dba-SQLServer] re: any ideas

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




More information about the dba-SQLServer mailing list