Cari Blog Ini

21 Maret 2012

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

Applies To:
Microsoft SQL Server 2005 Express Edition

Error Messages :

Restore failed for server 'xxx.xxx.x.45\sqlexpress'. (Microsoft.SqlServer.Express.Smo)

Additional information: 

An exception occurred while executing a Transact-SQL statement or batch 

(Microsoft.SqlServer.Express.ConnectionInfo) 

CREATE DATABASE or ALTER DATABASE failed 

because the resulting cumulative database size 

would exceed your licensed limit of 4096 MB per database.

RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 1827)






Condition:
Error happens when want to restore file "HRD_db_20120313300.bak"


File that want to restore:

Size actually of Database:



Causes:
The limitation of database size.
Maximum database size is limited to 4 GB (log file size is not counted)
Note : Network Packet Size = 4096



Solution:
Use the alternative version of Microsoft SQL Server.