How do I decrease the size of my sql server log file?

  • 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)

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)