I have a fairly large database that I thought was being well maintained, but the transaction log has grown large (7GB). We run a transaction log backup hourly. Each night it runs the following commands:
backup tran dbname with no_log
backup database dbname to dbname_backup with init
There are further commands in the job to reindex the database, and then shrink it with:
dbcc shrinkdatabase (dbname, 10)
These commands were provided by the vendor of the software, and have been running well, but the size of the transaction log worries me. I was thinking of adding a command to the nightly backup to shrink the log, but wanted some input first. Also, if I do this, is it going to take a long time to shrink it down the first time?
Any advice is really appreciated.