Post reply

how to find when the SQL server Last started?

  • February 15, 2012 at 12:04 pm

    #255761

    how to find when the SQL server Last started?

    thanks in advance !!!!!!!!!!!!!

  • February 15, 2012 at 12:06 pm

    #1447475

    You can simply check it by tempdb creation date time. 🙂

    java

  • February 15, 2012 at 12:09 pm

    #1447477

    another way

    select sqlserver_start_time from sys.dm_os_sys_info

  • February 15, 2012 at 12:09 pm

    #1447478

    Login date of any of the system processes (session_id 1 is easy enough)

    Creation date_time of TempDB

    There are others, but those are among the easiest (and work on all current versions of SQL)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 15, 2012 at 12:11 pm

    #1447479

    Also you can find server start time in SQL server Error log.

    java

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

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