When the dev database run in full recovery mode and do not have requirement to backup the database and transaction log, you can run the following commands to keep the transaction log size under control. backup database dbname TO DISK = 'NUL' BACKUP LOG dbname TO DISK = 'NUL'