DB logs file exceeded 80GB limits and shut down the application. It is happening from weekly to 3 times per week to nightly
File size was 6 GB from Monday night to Tuesday morning 80 GB in 36 hours with current number of transactions
Is there way to find out what is the root cause of the issues.
will ldf file analysis will help us . The database has been set to full recovery model(Microsoft SQL Server 2008 R2 (SP1) - 10.50.2550.0 (X64) )
mdf file (3295 mb) ,By 1 MB , unrestricted growth
ldf file 3402 mb ,By 10 percent ,restricted growth to 2097152 MB
how do we decrpyt ldf files to find out the root cause. Any DMV (select * from ::fn_dblog(null,null)) .
Please help .