Post reply

SQL service stop date

  • July 1, 2021 at 9:43 am

    #3902411

    Hello

    is there a Powershell command or through windows to know since when my SQL service is stopped

    Sans titre

    Thanks

  • July 1, 2021 at 7:54 pm

    #3902614

    Ah... sorry... you're asking for when it was stopped.  Might be a different lookup so I withdrew my previous post.

     

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • July 1, 2021 at 8:50 pm

    #3902643

    You can check the SQL Server logs - if the service is currently stopped then the last row in the log will tell you when it stopped.  This should also tell you whether it failed, was shutdown - or froze.  If the service is running, you can look at the previous log file to see when the service was stopped - and the current log file will show you when it was started.

    However - if you have a process that automatically cycles the logs then you may not be able to get back to the log file where the service was last stopped.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • July 22, 2021 at 2:38 am

    This was removed by the editor as SPAM

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

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