Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Simple Recovery model - Huge Trans Log

Status
Not open for further replies.
GCL2007

GCL2007

IS-IT--Management
Dec 11, 2007
167
US
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?
Thanks!
 
Status
Not open for further replies.

Similar threads

JScannell
  • Locked
  • Question
SQL login on Classic ASP localhost site
Replies
0
Views
245
JScannell
JScannell
RRinTetons
  • Locked
  • Question
SQL Server 2008 R2 login auditing
Replies
0
Views
233
RRinTetons
RRinTetons
RRinTetons
  • Locked
  • Question
Logging into a database using SSMS from non-domain machine
Replies
1
Views
312
fredericofonseca
fredericofonseca
joblack23
  • Locked
  • Question
Large transaction log file
Replies
5
Views
174
joblack23
joblack23
simian336
  • Locked
  • Question
Logins Per Second
Replies
0
Views
78
simian336
simian336

Part and Inventory Search

Sponsor

Back
Top