by ahahum » Wed Feb 10, 2016 9:27 pm people like this post
Is it possible to restore from a Veeam backup that was taken without processing the transaction logs while retaining the ability to restore to a point in time (In SQL native tools) using the transaction log backups taken using the native SQL tools?
If so, how since there is no bak file to start with? My understanding (not a DBA, but I've dabbled) is that you must begin the restore process with a bak file containing the full SQL database backup and then replay the transaction logs.
by alanbolte » Fri Feb 12, 2016 1:20 am people like this post
The short version is, if you want to backup sql logs with native tools, you should create .bak files with native tools as well. If you're doing this, set the Veeam backup to "copy only" in the AAIP settings.
by ahahum » Fri Feb 12, 2016 3:54 pm people like this post
alanbolte wrote:The short version is, if you want to backup sql logs with native tools, you should create .bak files with native tools as well. If you're doing this, set the Veeam backup to "copy only" in the AAIP settings.
by mdelmastro » Tue Feb 21, 2017 6:15 am people like this post
Hi Question please
We require Veeam to restore the SQL database from application-aware Veeam full/incremental backups, but leave the database in RECOVERY mode so that we can then manually apply transaction logs that we have not backed up through an application-aware Veeam backup. This requirement has arisen because we will be operating log-shipping, which manages transaction log backups through SQL Agent jobs, as opposed to backing them up through an application-aware Veeam backup.