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

Article:TECH129150  |  Created: 2010-01-23  |  Updated: 2014-04-29  |  Article URL http://www.symantec.com/docs/TECH129150
Article Type
Technical Solution


Issue



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



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.


Supplemental Materials

SourceETrack
Value2029567
Description

AVVI: APP GRT based restore for a SQL DB fails when the mdf\ldf\installation files reside other than the default location on C drive.



SourceError Code
Value0xe000fedf
Description

A failure occurred reading an object.


SourceError Code
Value0xe0009741
Description

Failed to mount one or more virtual disk images.Restores that use Granular Recovery Technology may not be available from this backup set.




Legacy ID



351379


Article URL http://www.symantec.com/docs/TECH129150


Terms of use for this information are found in Legal Notices