Follow via:
RSS
Email Alert
Question
0 Votes
+ -

SQL Server Transaction Log Large & Simple Recovery Model

I have a database that is in Simple Recovery mode and yet the Transaction log is very large - over 1 Gb and larger than the database. There is no concurrent sessions. I ran Checkpoint. Is there any danger in truncating the transaction log after a full backup? BTW, auto shrink option is NOT selected in the database options.
8th May 2007
Answer the question
Formatting +
BB Codes - Note: HTML is not supported in forums
  • [b] Bold [/b]
  • [i] Italic [/i]
  • [u] Underline [/u]
  • [s] Strikethrough [/s]
  • [q] "Quote" [/q]
  • [ol][*] 1. Ordered List [/ol]
  • [ul][*] · Unordered List [/ul]
  • [pre] Preformat [/pre]
  • [quote] "Blockquote" [/quote]

Join the TechRepublic Community and join the conversation! Signing-up is free and quick, Do it now, we want to hear your opinion.