Unable to perform snapshot Backup when multiple SQL 2012 databases are selected in the Backup Job

Article:TECH187693  |  Created: 2012-04-29  |  Updated: 2012-04-29  |  Article URL http://www.symantec.com/docs/TECH187693
Article Type
Technical Solution


Issue



Unable to perform snapshot Backup when multiple SQL 2012 databases are selected in the Backup Job


Error



Backup Exec locks up if more than one SQL 2012 database is attempted to freeze during a snapshot backup.


Environment



SQL 2012 and Backup Exec 2012


Cause



sysadmin role for the NT authority\system account is deselected in SQL 2012


Solution



This Issue is fixed with Backup Exec 2012 Hotfix 180962

Workaround :
1) Open SQL Management Studio
2) Click on security->logins
3) Enable the sysadmin role for the NT authority\system account. 


Supplemental Materials

SourceETrack
Value2729246
Description

Cannot perform snapshot of multuiple SQL databases with SQL 2012




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


Terms of use for this information are found in Legal Notices