backup up sql db and logs question
Posted on 2010-11-20
I recently took charge of a database on sql server 2005 at a new company and I see this in the Event Viewer:
Event Id 8309
BACKUP LOG WITH TRUNCATE_ONLY or WITH NO_LOG is deprecated. The simple recovery model should be used to automatically truncate the transaction log.
I looked at the job that is running and its:
BACKUP LOG [CompanyDB] WITH TRUNCATE_ONLY
DBCC SHRINKFILE (N'CompanySQL_log' , 0, TRUNCATEONLY)
This database is in SIMPLE RECOVERY MODE which is fine since its a data warehouse and not transactional.
So my question is: I was going to disable this sql job but wanted to double check and make sure I don't need it and I am not going to mess anything up. any input or thoughts, thanks.