SQL redirect restore to SQL Express instance fails with error cumulative database size would exceed licensed limit

Article:TECH172151  |  Created: 2011-10-19  |  Updated: 2013-04-09  |  Article URL http://www.symantec.com/docs/TECH172151
Article Type
Technical Solution


Subject

Issue



SQL database redirect restore to SQL Express instance fails with error


Error



0xe0008492 - Database Query Failure. See the job log for details.

V-79-65323-1827 - CREATE DATABASE or ALTER DATABASE failed because the cumulative database size would exceed licensed limit of 4096MB per database.

 


Cause



This error caused by database limitations.

SQL Versions Express Standard Enterprise Workgroup
2005 4GB No Limit No Limit No Limit
2008 R2 10GB 524TB 524TB 524TB

Solution



1. Install full version of SQL on the target server.

2. Perform SQL redirect restore.

Refer: http://www.symantec.com/docs/TECH56694

 


Supplemental Materials

SourceError Code
Value0xe0008492
Description

Database Query Failure. See the job log for details.


SourceUMI
ValueV-79-65323-1827
Description

CREATE DATABASE or ALTER DATABASE failed because the cumulative database size would exceed licensed limit of 4096MB per database.

 




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


Terms of use for this information are found in Legal Notices