Issue – vDP 6.1.2 – Restore from an SQL Database failed

Reading Time: 2 minutes

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

Hello,

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.

Screenshots from the Jobs:
vDP6-SQL restore success

vDP6-SQL restore failed message - vcenter Screenshots from the Consoles:vDP6-SQL restore failed message vDP6-SQL restore failed message - vcenter all

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.

Cheers,

Rolf

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...