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

Article:TECH188033  |  Created: 2012-05-03  |  Updated: 2013-07-25  |  Article URL http://www.symantec.com/docs/TECH188033
NOTE: If you are experiencing this particular known issue, we recommend that you Subscribe to receive email notification each time this article is updated. Subscribers will be the first to learn about any releases, status changes, workarounds or decisions made.
Article Type
Technical Solution


Issue



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



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)
 


Supplemental Materials

SourceETrack
Value2772989
Description

CTLG: Unable to select previous restore dates for SQL databases when attempting restore via FQDN.




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


Terms of use for this information are found in Legal Notices