November 21, 2006 at 4:45 am
Dear everyone,
Can i help me to solve my problem?? i want to read my log file, bcz i want to see who performed deletion operation yesterday. and i have only full backup of my database on daily basis...
i want to get info from log file .ldf. how it is possible??
Thanks !!
Noman
November 21, 2006 at 6:23 am
This is really tricky to get the information you want without using a 3rd party product. There are several of these on the market (e.g. Lumigent Log Explorer, Redgate SQL Log Analyzer).
There is an UNDOCUMENTED command in SQLServer to display log records - DBCC LOG - but the output is not very user-friendly, and probably won't show you exactly what you want.
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1173464,00.html
November 22, 2006 at 8:23 am
your best bet is to set up some triggers and audit tables to capture some operations for future auditing
November 22, 2006 at 2:52 pm
Yes definitly we have set some plan for our future.
but the question was about the past. How can i read my log (ldf) file.????
November 26, 2006 at 3:07 am
Lumigent Log Explorer can help.
November 26, 2006 at 9:59 am
Log PI from Golden Gate, Log Explorer from Lumigent, Apex Log from Apex, or Log Rescue from Red Gate can help you out if you save off the log backups.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply