Link to home
Start Free TrialLog in
Avatar of VBdotnet2005
VBdotnet2005Flag for United States of America

asked on

restart SQL Server

Is there a way to restart SQL Server at a specific time daily and keep a log of it?
Avatar of Sirees
Sirees

Avatar of Aneesh
You can use a windows tak manager to do this

first you create a batch file to do this


NET STOP MSSQLSERVER
NET START MSSQLSERVER

and schedule this
just curious why would you want to restart the SQL Server every day?
Avatar of VBdotnet2005

ASKER

It is not me really who wants to do it daily. We have one SQL Server and the other guy he wants to do it. Maybe that is away of his to get around the problem. Is that a bad practice?
Of course, there is a VB.net  program tight to this.
>It is not me really who wants to do it daily. We have one SQL Server and the other guy he wants to do it. Maybe that is away of his to get around the problem. Is that a bad practice?

it IS bad practice usually, please get the other guy to expose his reasons.
If he only tells he has heard that... then he should stop doing this way.

Tell us what process should be implemented that seems to require a daily restart, and we will try to give the alternatives
It is going hard to get the reason(s). I'm not going there.  What are the potencial problems? Thank you in advance.
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial