Scheduled JOB to bounce SQL

  •  

    Does anyone use a job to “Bounce” (stop/start) SQL server?   What commands are best to use for a job that bounces SQL weekly or even daily? My client's main application slows down in time but all is well after stopping and restarting SQL server. Instead of waiting for the next time they complain about slowness and doing this during the day, I want to create and run a job to bounce the server during off hours.  I hope to hear from my more knowledgeable peers with best practices and warnings for this instead of having to learn the hard way.

  • You could schedule a windows schedule job to run net stop service been the sql service and than start it would not run it from a SQL Job.


    Kindest Regards,

    bryan.oliver@quest.com

    quest.com

Viewing 2 posts - 1 through 1 (of 1 total)

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