Could not allocate space for object

Could not allocate space for object dbo.DELTA_0001 in database dsdelta 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…

Application Message ID: N/A

Symptoms

This error is reported in the DS-Client event log during backup (initial backup or regular backup) or during synchronization.

Cause

1) The drive where the dsdelta database files ( dsdelta.mdf / dsdelta.ldf ) are located is running out of free space. 2) The file system on the disk where the database files are located is fat32 ( this one has a 4GB file size limitation ) and the database files are larger than 4 GB. 3) The SQL Server instance holding the DS-Client databases is an Express edition and the maximum database size limit imposed by Microsoft (4 GB for SQL Server 2005 Express or 10 GB for SQL Server 2008 R2 Express or newer) has been reached.

Workaround

1) Clear up some space on the drive which is running out of space or move the database files ( using a supported SQL Server procedure like detach / attach ) to another drive with sufficient space available. 2) Convert the file system to NTFS ( if supported ) or move the database files to a disk formatted NTFS. 3) – Check the current version and edition of the SQL Server instance holding the DS-Client database (go to DS-User > Help > About DS-User > DS-Client info, "DBMS" field, for example if that field shows 10.50.2500 it means the SQL Server version is 2008 R2 SP1). – if the SQL Server Management Studio has not been downloaded and installed on the computer holding the SQL Server instance mentioned above please download it from Microsoft and install it, make sure you download the same version as the SQL Server (e.g. SQL Management Studio 2008 R2 with SP1). – open and connect with SQL Server Management Studio to the SQL Server instance holding the DS-Client databases, then right click on dsclient database > Properties > General, check the size of the database, repeat the procedure for dsdelta database and any expand000nr (if there). – if the size of any database is larger than 10 GB you need to ensure that the switch "automatically expand DS-Client database" is selected in DS-User > Setup > Configuration > Parameters, then run a weekly admin (deselect sync backup sets option to be faster). The weekly admin can be run manually from DS-User > Setup > System activities. – once the weekly admin completed check again the size of DS-Client databases in SQL Management studio, if the size of any database is still close to 10 GB you can run a shrink of that database: a) stop DS-CLient service (at a time when no activities are running); b) in SQL Management Studio right click on the intended database > tasks > shrink > database, then click ok (leave deselected the option "reorganize …). In that shrink pane you can also see how much space will be released.