Question:
I have been getting the following error on Remote DBs lately:
Could
not allocate space for object ‘dbo.INDEXUPDATES’ in database
‘SLXRemote’ 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.
I have noticed that the problem users are those who have an older DB (1yr old +) so I see this as an SQL maintenance issue.
Answer:
By recurring you are just delaying and avoiding the real issue which is
that your database is too large for SQL express/msde. You should reduce
size of database by setting filters on tables such as history etc. Or
upgrade the remotedb server to full SQL sever where the database size is
not deliberately restricted,
