2/13/2023 0 Comments Veeam backup logsAnyone have an experience with Veeam and transaction log truncating? All my reading and experience says that performing a TRUNCATE on a transaction log is not something that should be done frequently and I am a bit worried that truncating after every backup could cause problems.Anyone have experience performing a point in time recovery of a DB from Veeam? Any advice, take aways, issues?.Veeam's setting for backing up transaction logs (for a database in FULL recovery model) is to TRUNCATE the log with each 'backup'.ĭB's are in FULL recovery model DB full back up daily, T-Logs backed up hourly We are using a mix of SQL Server 2012-2017. ![]() I have years of SQL developer/architect experience, but am relatively new in the DBA role. The hospital that I work for has started to use Veeam for backing up our physical and virtual servers, including SQL Server.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |