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

EcoStruxure Building Operation, TAC INET

Environment

I/NET

SQL Server

Cause

Each SQL express version has its own database size limit. Refer to SQL and version compatibility for Filemaster, Equalized Client, Remote Client, Limitations of SQL.

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 datab...

The solution in just steps away!

Create account

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

Related Forums

Intelligent Devices Forum