SQL Server Performance

SQL Server Shutdown time and next recovery time

Discussion in 'General DBA Questions' started by pchee373, Mar 1, 2010.

  1. pchee373 New Member

    Has any one seen in their SQL Server error logs where the Shutdown time from a previous log is later then the recovery time from the next log?
    For example
    ERRORLOG1
    2010-02-19 23:11:07:05 SQL Server terminating because of system shutdown.
    ERRORLOG
    2010-02-19 23:08:42:07 Recovery Complete.
  2. satya Moderator

    What is the service pack of this SQL instance?
    It is an informational message, as long as you don't see any issus after DB recovery you can ignore.
  3. rohit2900 Member

    Hi..
    I agree with Satya and you can ignore these messages unless you have issue with recovery of any database but just would like to aks few things..
    What was the sql service start time for next log???
    Did somebody changed the system date??

Share This Page