Hardware VMware Host: Fujitsu PRIMERGY RX600 S6
Hardware VMware Storage: Fujitsu ETERNUS DX90 S2
Software VMware vCenter Appliance: VMware vCenter Appliance 6.0
Software VMware vDP: VMware Data Protection 6.1.2
Problem: vDP 6.1.2 – Restore from an SQL Database failed
I had the Problem that the Restore of an SQL Database failed with the vDP 6.1.2. Here are the Screenshots from the Issue.
In the log was following:
2016-07-06 12:06:52 avsql Error : Database TESTSQL01\SQLEXPRESS/db_Test will be skipped because it does not exist or is offline and a tail-log backup could not be performed.
2016-07-06 12:06:52 avsql Error : No targets after expansion!
2016-07-06 12:06:52 avsql Error : Recovery cannot be performed, all targets were excluded from restore.
2016-07-06 12:06:52 avsql Info : Final summary generated subwork 1, cancelled/aborted 0, snapview 0, exitcode 536870919
2016-07-06 12:06:57 avsql Info : avsql returning with exitcode 536870919
From the Administration Guide VMware vSphere Data Protection Documentation (Page 208)
A SQL Server restore with the tail-log backup option selected fails
This problem can be caused if the last restore was performed after the last full backup. Perform a full backup on the database before restore.
The restore can also fail if the Tail-log backup restore option is enabled and the database does not exist or is offline. In this case disable the Tail-log backup option.
So I enabled REPLACE and disabled Tail-Log Backup and then it worked.