VBdotnet2005
asked on
restart SQL Server
Is there a way to restart SQL Server at a specific time daily and keep a log of it?
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
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?
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?
ASKER
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 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
ASKER
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://vyaskn.tripod.com/restart_sql_server_service.htm