MSSQL transaction log problems

7 Oct

so the transaction log of this stupid piece of software has completely filled up once again… that’s what worked for me last time:

1) DB -> Tasks -> BackUp

  • Backup Type: Transactional
  • Backup To: Disk
  • -> OK

2) DB -> Tasks -> Shrink -> Files

  • File Type: Data
  • press the “Script” button
  • press “OK”
  • hit “F5”