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 database in I/NET. And also follow Archiving and SQL database size keeps growing 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 How to Troubleshoot on DBCreate for more issues about DBCreate.
