CODEWITHSUNDEEP
sql-serverdatabasesql-server-2008logfile
Sohail
Sohail

Reputation: 85

How to reduce log file size of MS SQL database

How to reduce log file size of MS SQL database. The requirement is to reduce log file of the version control server's DB, Shrinking is not an option in our case.

Upvotes: 3

Views: 3374

Answers (1)

S3S
S3S

Reputation: 25112

How to reduce log file size of MS SQL database

Shrinking is the only option here, but you need to clear out the log by backing it up first. Otherwise, there won't be any free space to shrink. After you shrink it once, you can keep it from getting blown out by either

  • Backing up your transaction logs more regularly. How often depends on your RPO
  • Setting the database to Simple Mode. This is only suggested if your RPO is large enough to where your FULL BACKUPs and DIFFERENTIALS would cover it.

Upvotes: 3

Related Questions