04-26-2010 02:22 PM
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.
To resolve this issue I have just been cutting new remote DBs for my users but I am wondering if there is a simpler way of dealing with this issue? I have the remote cutting and deployment down to an artform (20 min start to finish) so its not an issue of time.
Any thoughts?
Solved! Go to Solution.
04-26-2010 02:36 PM
04-26-2010 02:45 PM - edited 04-26-2010 02:45 PM
Thanks Mike,
I want to avoid table filters for now until I have my ownership of accounts set up by sales regions. I think by doing this I will have the only necessary filter to keep my remote DBs from filling their DBs with useless information that does not apply to their region.
Once I have this in place I can look at other tables to filter if needed.