we are using Veeam Backup&Replication for standby replication from one Hyper-V host to a second one - so our virtual maschines are replicated every 4 hours to the standby hypervisior.
now we wanted to test some restore scenarios and ran into some troubles on our SQL server.
At the replication job the "Guest Processing" is enabled and set to copy only.
"Real Backup" (full and log) is done directly by SQL maintenance plan (daily full, hourly log).
now we tested the function "Restore Database" in SQL management studio and when i want to restore via Timeline the last checkpoint is the last Copy-Only full backup of veeam and not the full backup of the maintenace plan. so i cannot restore.
is there a way to disable the checkpoint creation for veeam copy-only backup? as i understood, copy-only backups should not "destory" the log backup chain.
you can see - the marked one is the full backup of maintenance plan - then 2 correct log backups. but then there is the veeam backup (copy only - next screenshot). the database_backup_lsn is correct, but the checkpoint_lsn is set to the last veeam backup, which should be the last full backup.
When i try to use the timeline - the last veeam backup is taken (except i want to restore directly after maintenance full backup)
i hope you understand my problem and can help me :=)