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: 2012-05-03  |  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

Product(s)

Languages

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



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



Workaround: Restore the database in question using the Netbois name instead of the FQDN.

Symantec Corporation has acknowledged that the above-mentioned issue is present in the current version(s) of the product(s) mentioned at the end of this article. Symantec Corporation is committed to product quality and satisfied customers.
This issue is currently under investigation by Symantec Corporation. Pending the outcome of the investigation, this issue may be resolved by way of a patch or hotfix in current or future revisions of the software. However, this particular issue is not currently scheduled for any release.  If you feel this issue has a direct business impact for you and your continued use of the product, please contact your Symantec Sales representative or the Symantec Sales group to discuss these concerns.  For information on how to contact Symantec Sales, please see  http://www.symantec.com Please be sure to refer back to this document periodically as any changes to the status of the issue will be reflected here.

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

Please Sign In

Login using SymAccount.

Knowledge Base Search

Knowledge Base Search

Rate this Article

Help us improve your support experience.

MySymantec

MySymantec

Contacting Support

Contacting Support