Re-starting SQL Server

Question

Post reply

Re-starting SQL Server

eletuw

SSCrazy

Points: 2464
More actions
March 28, 2003 at 8:08 am

#58949

Does anyone know how to restart SQL Server unattended over a weekend. Something like a scheduled restart of the server.
Thanks.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Jeremy Kemp SSCertifiable Points: 6754 More actions · Answer 1

You can use:

net stop mssqlserver

net start sqlserver

in a .bat file executed using the at command to execute at a specific time. You will need to handle any questions it asks such as stopping dependent processes or work out what they are and stop them with their own command.

One question - why do you want to stop and start the server?

Jeremy

mybid2003 SSCertifiable Points: 6620 More actions · Answer 2

You can also do the following:

@ECHO OFF

NET STOP SQLSERVERAGENT

NET STOP MSSQLSERVER

SLEEP <<TIME INTERVAL>>

NET START MSSQLSERVER

NET START SQLSERVERAGENT

For more info, you can check this page:

http://vyaskn.tripod.com/restart_sql_server_service.htm

.

Rodrigo Acosta SSC-Insane Points: 21261 More actions · Answer 3

You should be very carefull about this. I would also configure the mail to advice me when the SQL Serve Agent start so I can know everyhing went right. You could schedulle a job to execute xp_sendmail when the agent starts.

mybid2003 SSCertifiable Points: 6620 More actions · Answer 4

Infact, you can write a procedure to automate the SQL Server Agent to start as soon as you restart SQL Server. For further info you can check this page:

http://vyaskn.tripod.com/code/sql_server_agent_autostart.txt

NOTE: Please read the "Usage:" section of this page carefully, before applying.

.

zach_john SSCertifiable Points: 5922 More actions · Answer 5

All of these are great ideas, but why not just cycle the server? One the scariest things I know of is approaching a box that hasn't been cycled in 18 months.

We use the shutdown.exe on the NT resource Kit through NT scheduler for scheduled monthly reboots. Make sure you use the auto restart, and force shutdown features.

Cheers.

John Zacharkan

mybid2003 SSCertifiable Points: 6620 More actions · Answer 6

Yes. Thats true. Even for my servers I have Monthly reboots scheduled. But if the servers are being used for some other apps as well in the production segment, then we would need to see their business needs as well. In such cases, if we need to just restart the SQL Server, we can follow the above methods, which will become very handy that time.

Let me know your thoughts!!!

.

eletuw SSCrazy Points: 2464 More actions · Answer 7

Thanks for all your help. The reason why I am doing this is to recycle the server. I noticed that whenever we reboot the server for an application upgrade there is an improvement in performance for a couple of weeks.