After upgrading to Backup Exec 2012, individual backup sets are not available for selection when attempting to restore a Microsoft SQL database(s) via FQDN

Problem

When attempting to restore a Microsoft SQL database via the FQDN of the server name, individual backup sets are not available for selections.  Only the most recent backup set can be restored.

Error Message

SGMon output when selecting via FQDN:

BECAT : [2860]:[4]: Input Parameters for FileHistory : [9](\\FQDN\MSSQLSERVER),[13](Database2),[62]({10011001-1001-1001-0101-010101010101}),[175](2),[181](1)
BECAT : [2860]:[5]: SQL connection: 1b096a90 select * from ControlInfo
BECAT : [2860]:[5]: SQL restore, netBiosLikeName ( \\FQDN\MSSQLSERVER ), fqdnLikeName ( .%\\FQDN\MSSQLSERVER ).
BECAT : [2860]:[4]: SELECT *, 0 FROM ImageObjectView where 1=1  AND RestoreType = 2  AND ( RestoreSubType & 1 = 1 )  AND ( ResourceName = \\FQDN\MSSQLSERVER or ResourceName like .%\\FQDN\MSSQLSERVER )  AND ExpirationPolicyID != '9D094A9C-BBBB-402c-A35D-8A46984A19D2'  AND ExtStatus & 536870912 = 0  ORDER BY  BackupTimeUTC DESC
BECAT : [2860]:[5]: SQL connection: 1b096a90 SELECT *, 0 FROM ImageObjectView where 1=1  AND RestoreType = ?  AND ( RestoreSubType & ? = ? )  AND ( ResourceName = ? or ResourceName like ? )  AND ExpirationPolicyID != '9D094A9C-BBBB-402c-A35D-8A46984A19D2'  AND ExtStatus & ? = 0  ORDER BY  BackupTimeUTC DESC
BECAT : [2860]:[4]:  result(0) numRetry(300)
BECAT : [2860]:[4]: Number of records returned: 0
BECAT : [2860]:[5]: CatDaoIterator:: Reset() return 0

 

Solution

A hotfix is now available for this issue in the current version(s) of the product(s) mentioned in this article. Refer to the Hotfix link under Related Documents at the end of this article to obtain the hotfix needed to resolve the issue.

Backup Exec 2012 Rev 1798 Service Pack 2 (TECH203155)
 


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)