database logs

  • 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.

  • 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.

  • 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