Home Forums SQL Server 2008 SQL Server 2008 - General Log LDF file RE: Log LDF file

  • August 23, 2013 at 1:20 am

    #1644260

    OnlyOneRJ (8/14/2013)

    Hi Gail,

    Requirenment here is to track if any update or delete happens by mistake, for which i am asked to take Log backups every 3 hours..

    Execution of the backups finishes in 10 minutes .. so not problem..

    Just a query that..

    In-case if any delete happens then how will i provide information using those Log backups??? do i need any tool for it???

    I would suggest turning on auditing and logging the events that you deem important. Be careful not to log to much because too much logging can have a negative impact on performance.