Post reply

database logs

  • June 18, 2003 at 11:16 am

    #59276

    Is there a way to check what happened to a specific database at a particular time? Are there any logs? I got complaints about db hiccups at specific time and lost some records. I dont see any in server logs.

    Any help greatly appreciated.

  • June 18, 2003 at 8:21 pm

    #462023

    quote:

    Is there a way to check what happened to a specific database at a particular time? Are there any logs? I got complaints about db hiccups at specific time and lost some records. I dont see any in server logs.

    Any help greatly appreciated.

    you may want to put a trace to see what the applications is really doing. many a times, the problem is with the apps.

  • June 19, 2003 at 2:45 pm

    #462283

    Use the trace to capture the transactions and see is there any DELETE's ? If you are using SQL 7.0 use the follwing one

    Exec xp_sqltrace Trace, @Fulltext = 1, @EventFilter = 115

    Shas3

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

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