Cắt giảm dung lượng file log của database.ldf

 

• Perform a full backup of your database. Don't skip this. Really.
• Change the backup method of your database to "Simple"
• Open a query window and enter "checkpoint" and execute
• Perform another backup of the database
• Change the backup method of your database back to "Full" (or whatever it was, if it wasn't already Simple)
• Perform a final full backup of the database.
• Run below queries one by one
  1. USE Database_Name
  2. select name,recovery_model_desc from sys.databases
  3. ALTER DATABASE Database_Name SET RECOVERY simple
  4. DBCC SHRINKFILE (Database_Name_log , 1)