Post reply

How to find out the last shutdown time by SQL Server?

  • September 28, 2010 at 12:54 pm

    #227406

    I don't mean the last start time by,

    SELECT create_date

    FROM sys.databases

    WHERE database_id = 2

    I need the last SHUTDOWN time.

    Thanks.

  • September 28, 2010 at 1:01 pm

    #1228620

    Look at the first archived sql log file

  • September 28, 2010 at 1:10 pm

    #1228625

    Ben:

    Could you explain the details please?

    Thanks.

  • September 28, 2010 at 1:26 pm

    #1228633

    Under the Management folder in SSMS, there is an error log folder. Look at the prior error log (errorlog.1) to determine when the shutdown was issued.

  • September 28, 2010 at 1:31 pm

    #1228637

    T-SQL alternative to what Steve had mentioned. Execute

    sp_readerrorlog 1

    The last entry in the output would give you the time when the instance was restarted

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

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

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