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)

No comments:

Post a Comment

PostgreSQL-Query: Sort result set by specific field values using ORDER BY Clause

Problem: Suppose we have a book_inventory table which has some columns such as id, isbn, title, author, publisher, publish_date, etc.. whe...