Troubleshooting Large Transaction Logs

Options: http://www.techrepublic.com/blog/the-enterprise-cloud/help-my-sql-server-log-file-is-too-big/

Ref:

• http://www.techrepublic.com/blog/the-enterprise-cloud/help-my-sql-server-log-file-is-too-big/
• http://sqlmag.com/sql-server/sql-server-log-files
• https://msdn.microsoft.com/en-us/library/ms190925.aspx
• http://sqlinthewild.co.za/index.php/2009/08/31/backing-up-to-nul-vs-backup-with-truncate-only/ -> https://msdn.microsoft.com/en-us/library/ms189275.aspx

Snippets:

Find Transaction Mode

SELECT name, recovery_model_desc

FROM sys.databases

Set Recovery Mode to Simple (for dev dbs, never for PROD)

ALTER DATABASE my_awesome_db

SET RECOVERY SIMPLE

Shrink Log File

From ssms:

1. Right-click DB
2. Tasks -> Shrink -> Files -> Log