June 18, 2003 at 11:16 am
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
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
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