After a successful restore of a SQL Database, the database is left un-attached when the option for "Leave the database nonoperational" is selected.

Article:TECH198181  |  Created: 2012-10-10  |  Updated: 2013-07-25  |  Article URL http://www.symantec.com/docs/TECH198181
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 performing a restore of a SQL database that was backed up with a VSS Snapshot the restore may not attach the database to the SQL Server if "Leave the database nonoperational; additional transaction logs or differential backups can be restored" is selected. 


Cause



This issue only occurs when the backup used snapshot technology for the SQL backup.

 


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
Value2959518
Description

SQL: Unable to leave restored database in restoring state when backup was taken with VSS




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


Terms of use for this information are found in Legal Notices