Question

Locked

SQL Server Transaction Log Large & Simple Recovery Model

By garymac12 ·
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.

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +
Back to Networks Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums