Fail to Restore the Backup from I/NET with SQL Database Size Limit is Reached

Issue

When restoring I/NET database backup from another server in DBcreate, it shows an error:

Error dropping PRIMARY KEY 'PK_DvrServers': Could not allocate space for object 'sys.sysserefs'.'clust' in database 'InetDb' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

Product Line

TAC I/NET, SmartStruxure Solution

Environment

I/NET

SQL Server

Cause

Each SQL express version has its own database size limit. Refer to Lessons Learned Article LL#4006.

If the database size limit is reached, I/NET database will fail to update. The backup of the database will be fine, but when trying to restore onto another computer, it will also fail.

Resolution

1. If the original I/NET server is still running, try to enable archive function to shrink the database in I/NET. And also follow Lessons Learned Article LL#13600 to set the database cap.

2. If the original I/NET server can't run, or the original database has been deleted, try to use SQL server version with higher size limit or full version SQL server which hasn't physical size limit. Like try to restore the backup from SQL 2005 Express (4GB limit) to SQL 2008 R2 Express (10 GB limit) or Full version of SQL 2005/2008.

Refer to Lessons Learned Article LL#15834 for more issues about DBCreate.