Hello Experts, my ldf is running out of space,the db is in simple recovery mode...
the db size is 1.8 tb,
database is not getting shrink,there is one recent open transaction also there are couple of process running on the is db...can you please advise.
asked Oct 13, 2012 at 09:57 AM in Default
If you cannot kill the process (you need to understand what the process is doing and whether it can be killed before simply killing it) then you have the option of increasing the logfile size or adding a new log file based on a different drive if you have no space on the drive currently used. This will only be a stop-gap solution to allow the long running transaction to complete.Once you identify why the transaction was running so long then you can decide on whether the logfile needs to be shrunk again
answered Oct 13, 2012 at 10:32 AM
To find the open transaction, you can use this script, written by Paul Randal:
Borrowed from here: http://www.sqlskills.com/blogs/paul/post/Script-open-transactions-with-text-and-plans.aspx
answered Oct 14, 2012 at 02:18 PM