I have a SQL Server 2008R2 database that we use as a date warehouse. It is large, data file is 42 GB, but the Trans log file is 80 GB and growing. It is a Simple database with Maintenance Plan backups every night. Much of the data gets loaded in from our ERP system. I don't understand seeing that it is Simple why the Trans Log is so large? Any options to shrink the Trans Log or is it best to leave it alone?
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.