SQL Redirect Restore fails with error "Unclosed quotation mark after the character string 'G:\SQL_D'"

Article:TECH198367  |  Created: 2012-10-15  |  Updated: 2013-07-25  |  Article URL http://www.symantec.com/docs/TECH198367
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



SQL Redirect Restore fails with error "Unclosed quotation mark after the character string 'G:\SQL_D'"


Cause



Backup Exec SQL redirect restore query which gets executed in the background is currently limited to 4096 characters. If the redirect restore query goes beyond 4096 the query will be truncated and would result in the above error. Restore to the same location should be fine.

 


Solution



Backup Exec 2010 Workaround :
Restore the SQL database to original location

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

SourceDEFECT
Value2964414
Description

SQL Redirect restore fails with the error "Unclosed quotation mark after the character string"


SourceUMI
ValueV-79-65323-105
Description

Unclosed quotation mark after the character string 'G:\SQL_D'




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


Terms of use for this information are found in Legal Notices