RE: automated stopping and restarting of sql services in 2000.

RE: automated stopping and restarting of sql services in 2000.

 

  

Another good opportunity for Openview or similar monitoring utilities to
alert DBA staff (via email or page) when SQL Server (or the agent) is
down.

-----Original Message-----
From: Jumma Salim
[mailto:mssqldba-ezmlmshield-x92264877.[Email address protected]
Sent: Friday, June 30, 2006 8:33 AM
To: LazyDBA Discussion
Subject: RE: automated stopping and restarting of sql services in 2000.


There should be some script to know how the server is working & is the
server getting slow over a period of time

Write a script to count till say 1000 and note the time

I wonder is something is ready


-----Original Message-----
From: Lucey Christine
[mailto:mssqldba-ezmlmshield-x83853376.[Email address protected]
Sent: Friday, June 30, 2006 9:15 AM
To: LazyDBA Discussion
Subject: RE: automated stopping and restarting of sql services in 2000.

Vendor recommendation to compensate for a problem the front end app has
with
releasing locks. :-P


-----Original Message-----
From: Jumma Salim
[mailto:mssqldba-ezmlmshield-x18316772.[Email address protected]
Sent: Friday, June 30, 2006 9:10 AM
To: LazyDBA Discussion
Subject: RE: automated stopping and restarting of sql services in 2000.


Dump question
What does stopping & starting sql server agent & sqlserver do

Whats the advantage & why its needed ???

-----Original Message-----
From: Lucey Christine
[mailto:mssqldba-ezmlmshield-x55543874.[Email address protected]
Sent: Friday, June 30, 2006 8:57 AM
To: LazyDBA Discussion
Subject: RE: automated stopping and restarting of sql services in 2000.

If you're talking about scheduled stops & restarts, you can use Windows
Scheduled Tasks to run simple batch files that do the job.

The command within the batch files is: net stop (example: NET STOP
SQLSERVERAGENT)
or net start (NET
START SQLSERVERAGENT)

I have to do this nightly on one of my servers. I run the batch files in
this order:
1. Stop SQLSERVERAGENT
2. Stop SQLSERVER
3. Start SQLSERVER
4. Start SQLSERVERAGENT
The commands run about 5 minutes apart from each other.

Probably there is a more elegant way to do this, but it works for me.

--Chris


-----Original Message-----
From: Todd Stover
[mailto:mssqldba-ezmlmshield-x40757602.[Email address protected]
Sent: Friday, June 30, 2006 8:41 AM
To: LazyDBA Discussion
Subject: automated stopping and restarting of sql services in 2000.


Anyone know how to reliably do this?



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
NOTICE: This transmission may contain confidential health information
that
is protected by special federal or state law or regulation. It is
intended
only for the use of the individual to whom it has been addressed. Only
the
person named in this transmission is authorized to view any information
contained herein. Re-disclosure without proper consent is prohibited.
Unauthorized use or disclosure or failure to maintain confidentiality
may
subject you to penalties under both federal and state law.


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
NOTICE: This transmission may contain confidential health information
that
is protected by special federal or state law or regulation. It is
intended
only for the use of the individual to whom it has been addressed. Only
the
person named in this transmission is authorized to view any information
contained herein. Re-disclosure without proper consent is prohibited.
Unauthorized use or disclosure or failure to maintain confidentiality
may
subject you to penalties under both federal and state law.


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

MS Sql Server LazyDBA home page