Post reply

stop/start SQL services

  • February 8, 2013 at 7:54 pm

    #268303

    Hi,

    If I need to stop/start sql services since Windows will be shutdown for some time, what is the best way to do it.

    I know I can stop/start services through config mgr, but what else I need to check and make sure before I stop/start services?

    SueTons.

    Regards,
    SQLisAwe5oMe.

  • February 9, 2013 at 6:24 am

    #1586219

    For stopping ad=nd starting a serving SQL Server Configuration Manager MMC, Windows Services MMC, WMI, PowerShell -Services cmdlets...all of those will work fine. If you're configuring services though, e.g. changing a service account name or password, it is recommended to use the SQL Server Configuration Manager MMC.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • February 9, 2013 at 7:56 am

    #1586227

    opc.three (2/9/2013)

    For stopping ad=nd starting a serving SQL Server Configuration Manager MMC, Windows Services MMC, WMI, PowerShell -Services cmdlets...all of those will work fine. If you're configuring services though, e.g. changing a service account name or password, it is recommended to use the SQL Server Configuration Manager MMC.

    I know how to start/stop, I am more concerned if there is mirroring, logshipping, cluster, etc.....what else you need to do before stopping services? That was my question...sorry if I wasn't clear.

    SueTons.

    Regards,
    SQLisAwe5oMe.

  • February 9, 2013 at 8:03 am

    #1586229

    log shipping will be fine. clustering and mirroring need more attention due to failover scenarios. also check for running Agent jobs.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • February 9, 2013 at 8:10 am

    #1586231

    opc.three (2/9/2013)

    log shipping will be fine. clustering and mirroring need more attention due to failover scenarios. also check for running Agent jobs.

    As far as jobs, I will stop the agent as well...because i was told that the server will be off for some hours....

    SueTons.

    Regards,
    SQLisAwe5oMe.

  • February 9, 2013 at 8:53 am

    #1586233

    I meant so that a job is not killed midstream by the service stopping. Also keep missed schedules in mind while the service is down.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 6 posts - 1 through 5 (of 5 total)

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