Oct 7, 2015

Truncate or Shrink a SQL Server log file



Many way you can shrink the log file, some trick is given below.

1. Management studio:
  • Don't do this on a live environment, but to ensure you shrink your dev db as much as you can:
  • Right-click the database, choose properties, then options.
  • Make sure "Recovery model" is set to "Simple", not "Full"
  • Click Ok
  • Right-click the database again, choose tasks -> shrink files
  • Change file type to "log"
  • Click ok.
2. By Command you can do as below


ALTER DATABASE YourDatabaseName SET RECOVERY SIMPLE
DBCC SHRINKFILE('YourDatabaseName_log', 0, TRUNCATEONLY)