2

Possible Duplicate:
Why Does the Transaction Log Keep Growing or Run Out of Space?

I am having trouble with my database, the log files is currently 250GB in size, I need to shrink this down somehow.

I have tried backing up the transactional log files, performing a full backup, running various shrink scripts but to no avail.

What are the correct steps to make this happen?

Can I somehow just truncate the whole log file then perform a full backup?

Thank You, Paul

Community
  • 1
Paul Hinett
  • 121
  • 3

2 Answers2

2

Do you need point it time recovery? If not then change the database's recovery model to Simple.

Does the database have mirroring or replication configured? That can also cause the transaction log to blow up quite large.

mrdenny
  • 27,106
  • 2
  • 44
  • 81
0

Paul Randal has a good post on this topic: http://sqlskills.com/BLOGS/PAUL/post/Search-Engine-QA-1-Running-out-of-transaction-log-space.aspx

Eric Humphrey - lotsahelp
  • 5,033
  • 1
  • 25
  • 29