I work for a government agency. Our backups are handled by OIT. But we also keep a couple backups of a crucial database on hand in case we need it and do not want to wait for OIT.
The database is configured as Simple recovery model. The perform a COPY_ONLY backup each night so it does not interfere with the OIT backup. As I understand it that should clear the log file each night. Yet on our development server for one database the log file has grown to 31GB. The log file on production server for the same database is about 250MB and is empty. There are no open transactions and I have tried shrinking the file but the file is 90% full on the development server.
Any suggestions on how to reduce the size of the transaction log to around 250MB like it is on our production server?