SQL server may hang up if some VSS error occurs

Article:TECH198700  |  Created: 2012-10-22  |  Updated: 2012-10-23  |  Article URL http://www.symantec.com/docs/TECH198700
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)

Subject

Problem



When performing SQL backups with Advanced Open File Option (AOFO), the SQL database and the backup job may hang up if some snapshot creation error occurs in the VSS operation.

 

 


Cause



This is caused by some snapshot creation error in the VSS operation.

 


Solution



Do not use AOFO in an environment where any snapshot error may occur.

 

If this issue is observed, kill beremote.exe on the SQL server with the following command to recover frozen state immediately

taskkill /f /im beremote.exe 

After the taskkill command, restart all services of Backup Exec on both Media Server and the remote server.

 

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

Production SQL server was frozen until stopping bengine or beremote



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


Terms of use for this information are found in Legal Notices