SQL Backup without processing the logs

[ahahum]

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.

[Vitaliy S.]

Hi Adam,

If you backed up all logs natively, then it should be possible to achieve that via SQL Management Studio. See this topic for more info > SQL Instant Recovery with Point in Time Restore

On a side note, why not to allow Veeam backup job handle this process?

Thanks!

[alanbolte]

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.

[ahahum]

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.

Will the VSS backup using veeam break the chain?

[Vitaliy S.]

Yes, If you don't enable COPY_ONLY mode, then it will affect your backup strategy via native tools.

[mdelmastro]

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.

[Vitaliy S.]

Hi Matthew,

If you want to manage logs through another too, then just set application-aware processing to COPY_ONLY mode.

Thanks!