TFS Power Tools to setup a db backup plan for a TFS 2010 instance using SQL Server 2008. The result is a sheduled full backup at 02:00 each night and a transaction log backup every 2 hours. The backups work but there is a problem with the transaction logs
not being truncated after backup. When this was brought to my attention typically all the transaction logs were 10-30 times larger than the data files... I searched the www and found these two useful commands:
SELECT name, recovery_model_desc, log_reuse_wait, log_reuse_wait_desc FROM sys.databases
For all relevant databases log_reuse_wait = 2 and log_reuse_wait_desc = LOG_BACKUP. The dbcc command told me that log files were about 95% in use.
Searched som more on thee www and ended up with this manual procedure to "fix" the problem:
- Right click db and select Tasks -> Backup...
- Change Backyp type to Trasanction Log and press Ok.
- Repeat steps 1 & 2. (Had to do it twice and
View Complete Post