SQL Server - Transaction Log - auto shrink?

[devvvy]

hello - how can you configure auto shrink for SQL server Trasnaction log? Thanks

dev

[Goutam Patra]

EXEC SP_DBOPTION 'MYDBNAME', 'trunc. log. on chkpt', true

modified on Wednesday, November 17, 2010 3:29 AM

[David Mujica]

Before you shrink/truncate your transaction log, make sure you have a proper backup so that you can recover the data. You may want to investigate the Simple Recovery Model for your backups. Read this article http://databases.about.com/od/sqlserver/a/recoverymodels.htm[^]