SQL Redirect Restore fails with error "Unclosed quotation mark after the character string 'G:\SQL_D'"
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.
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)