Archive for October 2011

MSSQL transaction log problems

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”