on Jun 14, 2016Article Content
| Article Number | 000020320 |
| Applies To | RSA ACE/Server 5.0.x (no longer supported as of 8-15-2004) RSA ACE/Server 5.1 (no longer supported as of 7-14-2006) Microsoft Windows NT 4.0 Microsoft Windows 2000 |
| Issue | ACE/Server database size doubles after sdload The size of the "sdserv.db" file after loading the dump (sdserv.dmp) file into a new install of ACE/Server 5.0.3 on another machine (different to original Primary and Replica machines) is effectively doubled A subsequent run of "sdcompress" on that database does not reduce the size of the database |
| Cause | This behavior is due to the fact that when you have large databases and you load the database in "merge" mode, delta records are created for each replica record in the database which causes the database size to almost double. For more information on Delta Records, see the solution titled What are Delta Records? |
| Resolution | Using the Compress utility again, perform the following steps: 1. Navigate to RSA ACE/Server -> DataBase Tools -> Compress -> Compress Server Database 2. Check the box "Do not load delta records" 3. Click "yes" to the warning You should then be able to compress your database. |
| Legacy Article ID | a16026 |