After a successful restore of a SQL Database, the database is left un-attached when the option for "Leave the database nonoperation" is selected.
|Article:TECH198181|||||Created: 2012-10-10|||||Updated: 2012-10-10|||||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.|
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 nonoperation; additional transaction logs or differential backups can be restored" is selected.
This issue only occurs when the backup used snapshot technology for the SQL backup.
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
Note: Customers experiencing this issue are encouraged to contact technician support as we are still collecting data on the issue.
SQL: Unable to leave restored database in restoring state when backup was taken with VSS
Article URL http://www.symantec.com/docs/TECH198181