What exactly happens when you reach the DB size limit?

Status
Not open for further replies.

chockomonkey

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
IMAP
We're about .5gb away from hitting the 4gb mark which BCM still tells us is our size limit.

I'm curious what happens exactly when this point is reached. Any info would be great.

I'm also curious why it is still showing the limit as 4gb, because according to this post here, the DB size limit of our version of SQL has been increased.

Thanks!
 

wallisellener

Senior Member
Outlook version
Outlook 2013 64 bit
Email Account
Exchange Server
I've just checked our database and we are nowhere near the size limit.

You will probably generate a gravitational wave that will obliterate all your BCM contacts :)
My assumption would be that bad things happen (much like in any other software ever made) when such limits are achieved/exceed.

Just out of curiosity: what kind of data was pumped to trigger such a growth?

Please do keep us updated, I'm looking forward to your findings.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
It will either warn (as it gets really close) or just stop working (when it's at the max). (Stop working is my guess, with no visible warning except in event viewer, but I've never hit it.) Did you try changing the max database size using the SQL Management Studio?
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange

chockomonkey

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
IMAP
I've just checked our database and we are nowhere near the size limit.

You will probably generate a gravitational wave that will obliterate all your BCM contacts :)
My assumption would be that bad things happen (much like in any other software ever made) when such limits are achieved/exceed.

Just out of curiosity: what kind of data was pumped to trigger such a growth?

Please do keep us updated, I'm looking forward to your findings.
Haha yes, it will likely be the end of the world of BCM as we know it... terrifying stuff.

Anyway... I know exactly what sparked this database growth--about 2 years ago we decided that, instead of attaching emails directly to the contact history, we would drag and drop the email from Outlook directly into a business note created per department.

Capture.PNG

This has made things very organized, but clearly has had the trade-off of massive database growth.

Capture.PNG

Using the built-in report, I can see that this has made the dbo.Attachments table quite large:
Capture.PNG


Does anyone know why there's so much "Unallocated" Space as shown in this below report?

Capture.PNG


It will either warn (as it gets really close) or just stop working (when it's at the max). (Stop working is my guess, with no visible warning except in event viewer, but I've never hit it.) Did you try changing the max database size using the SQL Management Studio?
I have not done this, nor can I find anything online about doing this. Will you point me in the right direction for changing the max database size?
I don't know how well BCM cleans up after itself, but a backup then compact to release unused space might help.

Is it 2005 or 2008 in your version of BCM?
2008: Download Microsoft® SQL Server® 2008 Management Studio Express from Official Microsoft Download Center
2005: Download Microsoft SQL Server Management Studio Express from Official Microsoft Download Center
Is the "compact" suggestion you're referring to the "Tasks > Shrink > Database" in Management Studio?

I'm using "Microsoft SQL Server 2008 R2 (SP2) Express Edition (64-bit)" with Management Studio
 

chockomonkey

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
IMAP
So I restored one of our backups to a new database for testing. Using the method I found at the below link, I increased the database size to well over the maximum 4gb showed by BCM.

How to: Increase the Size of a Database (SQL Server Management Studio)

Initial testing was slow... however I believe that now to be a side-affect of being a completely new database. The more I tinker around with it, the faster it gets. My guess is there's some caching which needs to take place at the start of a new database which has lots of information already.

Anyway, this is how it looks on this development database.

Capture.PNG


No errors nor issues thus far.
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
J What exactly does the BCM Database tool actually do? BCM (Business Contact Manager) 3
F print exactly one month per page in Outlook calender Using Outlook 2
J Change POP account to Forwarder - What happens in Outlook? Using Outlook 2
makinmyway Trouble Installing BCM Outlook 2013; Endless Install Loop Happens Using Outlook 0
J Nothing happens after clicking on the link in my emails Using Outlook 3
G What event happens when you open 2 copies of your inbox? Using Outlook 5
W Nothing happens when using the Archive Using Outlook 3
D Outlook will not import backup copy of contacts. I have tried file-import-etc. but nothing happens. Using Outlook 3
D What happens to the doccuments when you uninstall the Office 2010 Beta click to Run program in Vista OS? Using Outlook 3
X What happens to the mailbox when you delete a user from AD Exchange Server Administration 3
T push "send/receive all folders" and nothing happens, check "Show progress" and it's empty. Using Outlook 10
K Outlook 2007: Nothing happens when searching PST file Using Outlook 0
B Delete or Move from a Search Result - Nothing Happens Using Outlook 2
Y What happens if i remove ExchangeSetupLogs directory? Exchange Server Administration 2
M What happens when i replicate to much system public folders from ex2003 to 2010 Exchange Server Administration 4
N The vertical scroll bar crashes to the bottom of the page and will not return to any point above the bottom. This happens in the email and the list of Using Outlook 1
D Outlook PST folders flashing when Outlook opens. Happens sporadicaly Using Outlook 2
S Strange things happens after migration to exchange 2010 Exchange Server Administration 3
M HELP! Microsoft Outlook 2003 has stopped working - what to do? Happens every time I open it. Just started happening today. Using Outlook 2
B Suddenly I cannot send email. I can receive OK, but can't send. I Checked with ISP, all good there. This only happens with my Outlook 2003 mail. I can Using Outlook 4
D What happens to the .pst files I have from office 2007 ? Using Outlook 3
V What happens when "Resource" recipients are put in To/cc boxes? Outlook VBA and Custom Forms 3
P Your message did not reach some or all of the intended recipients. Using Outlook 2
C Your message did not reach some or all of the intended recipients. Using Outlook 2
A Your message did not reach some or all of the intended recipients.____ Error Notification "Undel Using Outlook 2
M Outlook yahoo POP3 outgoing messages are not reaching destination. Sometime the messages reach the Using Outlook 10
L Outlook 2010 deleting items before they reach my inbox on send/receive Using Outlook 3
T Bounce error. System Administrator ... Your message did not reach some or all of the intended recip Using Outlook 2
B Netopia 3D Reach Wireless Adapter and Outlook 7____ Using Outlook 1
N "Your message did not reach some or all of the intended recipients" Outlook 2007 Using Outlook 2
Similar threads






























Top