Backup Exec 2010 AVVI: Individual database level restore from an Application GRT enabled backup set of SQL virtual machine fails if SQL applicaion or its database is running in a non-default location

Problem

An individual database level restore from an Application Granular Recovery Technology (GRT) enabled backup set of a SQL server Virtual Machine created using the Agent for Virtual VMware Infrastructure (AVVI) fails if the SQL application or its databases is running in a non-default location.
 

Error Message

If the restore is being done from a DISK backup set, the error received is as follows:
-------------------------------------------------------------------------------------------------------------------
The database server is not responding. Backup set canceled.


Completed status: Failed
Final error: 0xe000fedf - A failure occurred reading an object.
Final error category: Resource Errors

If the restore is being done from a TAPE backup set, the error received is as follows:
--------------------------------------------------------------------------------------------------------------
Completed status: Failed
Final error: 0xe0009741 - Failed to mount one or more virtual disk images.
Restores that use Granular Recovery Technology may not be available from this backup set.
Final error category: Resource Errors

Restore

 The Virtual Machine resource is not responding. Backup set canceled.


The Backup Exec Remote Agent debug log on the Backup Exec server reports the following errors:
-----------------------------------------------------------------------------------------------------------------------------
brUtil::OpenActiveObject Error: 0xE00084AF Could not open the object sqldatabase.mdf e:\sqldata\sqldatabase.mdf
OFF_HOST_FS::ReadObj( ) pBrUtil->ReadObject( ) Error status CODE (E00084AF)
UpdateSqlPdi: failed to read object info 0xe000fedf
Detach from SQLSERVER.test.dom\SQL2K8
brUtil::brUtil Destructor
Detach from G:
FS_FreeOSPathOrNameQueueInHand: Error. QueueCount( &fsh->in_use_name_q ) != 0
CommonMounter::MountSomeApp: UpdateSqlPdi processing error -536805665 0xe000fedf
VM_VCBPROXY_PDI_FS::JumpToImgBrowser: failed to mount some disk(s).
 

Cause

This problem is not seen if the SQL application is installed in its default location on C:\ and the databases are also located in the default locations on C:\.

 

Solution


Workaround:


Disable the Application GRT option for the SQL Virtual Machine. To protect the SQL databases, run a direct backup of the virtual machine using the Remote Agent/SQL Agent instead of the AVVI option.

Resolution:

This issue has been resolved with Hotfix 354451 (and is included in subsequent service packs) in Backup Exec 2010. See the related documents for download information.

Note: This hotfix only corrects this issue with all of the VMDK's reside on the same datastore.  If the VMDK's reside on different datastores please continue to use the workaround.


Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)