On SQL Server 2008 R2, am running into a problem with Transaction log files getting too large and am running out of space. For example, I have log files of 96000000 KB, and two at 50000000 KB. We tried changing recovery model to simple, but that didn't help us recover space. What are the steps I need to do to free up space.. I think this is a basic problem, but I come from an Oracle background... Thank you! If someone could tell me the steps, I would greatly appreciate it before my disk fills up...
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.