simple backup not available in management studio
Posted on 2009-07-07
I have a database that is scheduled to backup once/day. I would like to reduce the log file size. I tried doing transaction log backups but the trn file created was 37GB. I tried to change the scheduled backup to be a simple recovery model but Management Studio/Maintenance plan/backup only allows me to select Full, Differential or Transactional. We don't need hourly transaction backups on this problem database. A daily backup will suffice. Our most important database is larger and has hourly transaction backups. Here is a comparison of this problem database with our bigger production database.
Problem db file sizes Production database file sizes
ldf 37 1
mdf 4 5
bak 3 5 (including trn files)
There aren't a huge number of transactions going on in the problem database.
How can I schedule a simple backup in Management Studio?