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.
Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…