SQL Express 2005 & Business Contact Manager 2007

Question

Post reply

SQL Express 2005 & Business Contact Manager 2007

njdouglas

Say Hey Kid

Points: 707
More actions
March 1, 2010 at 1:48 pm

#230442

Hi,
I have a customer running Outlook 2007 with Business Contact Manager 2007 and SQL Server Express 2005. OS is Windows 7 Pro 64 bit with 4 GB RAM, Quad Core CPU and loads of free disk space (300GB +).
When they attempt to add, edit, delete a contact or email they get the following error:
"could not allocate space for object 'dbo.changequeue' in database
'mssmallbusiness' because the 'primary' filegroup is full. create disk
space by deleting unneeded files, dropping objects in the filegoup, adding
additional files to the filegroup, or setting autogrowth on for existing
files in the filegoup."
Also if I try emptying the deleted item folder in BCM I get:
"Some items cannot be deleted. They were moved or already deleted, or access was denied"
My primary database file is 3.16 GB in Windows Explorer. From looking around the web I get the impression the SQL database is full (although I'm only using 3.16GB of the 4 GB I'm supposed to get with SQL Express). The deleted items folder has just over 1000 items in it yet I cannot delete them. The main cause of the large database size is the "communications items" in BCM which contains 400,000 (thats four hundred thousand) email items from email marketting campaigns. These do not need to be kept and again could be deleted but it won't let me.
Any help is much appreciated as this database now cannot be modified in any way.
Thanks
Neil

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

thasteve SSCrazy Points: 2707 More actions · Answer 1

thasteve

SSCrazy

Points: 2707

March 1, 2010 at 2:12 pm

#1126703

you have to add the size of the log file to 4gb

njdouglas Say Hey Kid Points: 707 More actions · Answer 2

OK, can you explain how I do that as I have very little SQL experience.

thasteve SSCrazy Points: 2707 More actions · Answer 3

use [my outlook crm db]

select file_id, name, physical_name, size*1/128 as sizeinmb from sys.database_files

njdouglas Say Hey Kid Points: 707 More actions · Answer 4

OK, sorry to be completely thick but that means very little to me! Is that a powershell command? Like I said I have very little sql experience so I need broken in gently!

Thanks

Neil

thasteve SSCrazy Points: 2707 More actions · Answer 5

ehm ok that might be to little for it... maybe you know in which folder the database files are in? with some luck there might be a similar named file with the extensions mdf and ldf?

njdouglas Say Hey Kid Points: 707 More actions · Answer 6

The files are in the C:\Users\%username%\AppData\Local\Microsoft\Business Contact Manager\" folder. there are two database type files called MSSmallBusiness.ldf and MSSmallBusiness.mdf . The MDF file is 3.16GB in size, the LDF file is about 80 MB in size.

Thanks

njdouglas Say Hey Kid Points: 707 More actions · Answer 7

njdouglas

Say Hey Kid

Points: 707

March 7, 2010 at 2:10 pm

#1129797

anyone else help with this?

njdouglas Say Hey Kid Points: 707 More actions · Answer 8

OK, situation just got a whole lot worse. The guy has continued using the database to do mailshots. The primary database file now sits at 4.75GB. How can I delete the communication history to get this datbase file size down?