Transaction log for database 'name' is full

  • Updated

Upon 8.5 upgrade, error The transaction log for database 'name' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

To fix this problem, change the Database Recovery Model from "Full" to "Simple". To do this

  1. Right click the database. 
  2. Open Properties. 
  3. Click Options. 
  4. Change the Recovery Model to Simple.