Post reply

Strange

  • February 9, 2009 at 6:58 am

    #97287

    Hi Experts,

    I am getting something strange in my SQL Server 2000.

    SQL Server log is showing events happened before 2 Hrs ie in the current SQL Server log if its 7 PM now it shows events happened during 5PM. Current and latest events are not shown

    Please help

    TIA

  • February 9, 2009 at 7:03 am

    #940451

    Does your system time match current time? If so, run something that will write an event to the SQL Server log like a DBCC CHECKDB (model) and see if you get an event written at the correct time. Post back your results.

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • February 9, 2009 at 7:13 am

    #940461

    As David mentioned, SQL Server gets its time from the system. If you don't have your systems syncing time with some source, it is easy for this to happen. Also, things like GETDATE() will appear to show the incorrect time.

    The easiest way to check immediately is a "SELECT GETDATE()", if that doesn't work, then run force a log entry in the database to see what's there.

    Is the file datestamp on the log correct? It should be based on the last write to that log. A DBCC ERRORLOG should cycle and create a new log with the current time on the file.

  • February 9, 2009 at 8:01 am

    #940497

    Thanks for the reply

    I checked the getdate and its showing current time and i got event in SQL Server log when i run DBCC CHECKDB.

    I have run some update statistics and index reorganize commands but they are not shown in SQL Server logs.

  • February 9, 2009 at 8:30 am

    #940522

    Ratheesh.K.Nair (2/9/2009)

    I have run some update statistics and index reorganize commands but they are not shown in SQL Server logs.

    Have you seen somewhere that these are logged events? I don't believe they are.

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • February 9, 2009 at 10:28 am

    #940649

    DavidB (2/9/2009)

    Ratheesh.K.Nair (2/9/2009)

    I have run some update statistics and index reorganize commands but they are not shown in SQL Server logs.

    Have you seen somewhere that these are logged events? I don't believe they are.

    They're not. CheckDB is, backups are, severe errors. Not much else is logged to the error log.

    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 10, 2009 at 2:18 am

    #941020

    Thanks to All

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

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