Best Practice for restarting a Server which hosts SQL2008 R2

  • Dear all - I've been asked to restart a Server which hosts SQL2008 R2 as requested by our Tech Services Department. Is it safe to just simply select the Windows start button & choose Restart?

    Many thanks

    Dax

  • yes that will safely restart a server for you without having to go to the console to reboot it.

    But it depends on why you have been asked to restart it as to whether its a good thing to do. If for instance you have a long rollback in operation, the database involved will just have to go through a long recovery stage on restart.

    ---------------------------------------------------------------------

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

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