[dba-SQLServer] SQL Server 2005 LDF Viewer

Paul Hartland paul.hartland at googlemail.com
Fri Sep 12 02:25:51 CDT 2008


To all,

Over the last two days we have been losing personnel off our main database,
and have had to retrieve them from one of my many backups.  However I can't
seem to see why or where this is happening in my application (VB6)...Does
anybody know how to view the LDF files, so that I can see each transaction
as it takes place, or if there is something I can do when a record is
deleted from tblPersonnel, or if I can turn on some sort of monitoring
system ?

Thanks in advance for any help on this.

-- 
Paul Hartland
paul.hartland at googlemail.com



More information about the dba-SQLServer mailing list