[dba-SQLServer] re: any ideas

Yes, the SQLServerAgent service *depends* on the MSSQLServer service.  If
you stop the latter, then the dependent services also stop - but not vice
versa.

Backing up files, rather than doing it properly?  Not smart.  But if they're
convinced they know better, you could say "Of course you do *test* your
backups by restoring them - don't you?".

John


> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com 
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf 
> Of Francisco H Tapia
> Sent: 15 March 2004 17:13
> 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
> 
>