• Thanks Steve, The reason is I forgot that the default is full when the database is created. We had a small crisis when the log disk got full over the weekend. We didn't need point in time recovery so we backed up the db and then switched to simple but the transaction log was still large. We ended up using dbcc shrinkfile to reduce the size. After reviewing, I found that there are other databases that were apparently created the same way before I came along.