Post reply

Rebooting Sql server

  • December 17, 2002 at 11:51 am

    #80089

    HI. I was wondering if there is a guideline as to how often sql server should be stopped and started. Should it be done on a normal basis or only as needed.

    Thanks, Juanita

  • December 17, 2002 at 12:05 pm

    #444619

    We are a long way from the norm on this, but we normally only reboot our boxes, if maintenance requires. This is around once a month or so, although sometimes longer.

    Gregory Larsen, DBA

    If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

    Gregory A. Larsen, MVP

  • December 17, 2002 at 12:34 pm

    #444624

    Hi Juanita,

    In our environment, SQL Server is only rebooted when the server itself needs to be rebooted. Otherwise, in our 24x7 shop, SQL Server always needs to be up and running because connections to the database are made around-the-clock.

  • December 17, 2002 at 1:09 pm

    #444627

    Thank you for the replies. That is exactly what I was looking for. Coming from a mainframe environment to a client server environment is causing me to ask a lot of questions as to 'HOW' and 'WHY' ..

    Thanks again..!

Viewing 4 posts - 1 through 3 (of 3 total)

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