Log in Register FAQ Memberlist Search ContactReview Forum Index
A GoldMine Discussion and Support Community

ContactReview Forum Index » GoldMine 7 (Corporate Edition) » GM 7.5 Database issues
Post new topic  Reply to topic View previous topic :: View next topic 
GM 7.5 Database issues
PostPosted: Mon May 14, 2012 9:01 am Points: 0 Reply with quote
stoessner
GoldMine Journeyman
Joined: 25 Feb 2009
Posts: 46
Location: Ohio




Hello All,

I have a GM 7.5 database size issue.

Not really sure what's going on but I will try to explain the best I can.

The database is about 8GB currently. We are running SQL 2008 on server. Last year at this time it was only about 4GB.....

Can anyone offer me some Mailbox cleanup ideas or maybe a way to keep it smaller??? Or maybe any other cleanup ideas to keep the database manageable???

I know it's a cryptic post, but I'm just not sure what's causing this data to grow so quickly and I am having issues getting all the data to sync to the remote when I set up a new user.

Any ideas are always appreciated.

_________________
Sally Stoessner
View user's profile Send private message Visit poster's website

PostPosted: Mon May 14, 2012 11:57 am Points: 0 Reply with quote
DJ
GoldMine Guru
Joined: 29 Jun 2006
Posts: 2055
Location: Fitchburg, MA, USA




I recommend that you have Users delete E-mail older than 2 Years. Remember that Attachments are not part of the database and have not increased the size. Make sure, after they delete them, that they Empty their Deleted Folder. Naturally, some companies are required to keep E-mails for longer.

FYI: 8 GB is not a large SQL Database if you have the equipment to handle it.

_________________
DJ Hunt

Phone: (978)342-3333
Email: DJ@DJHunt.US

GoldMine Premium - The Defintive Guide
One-on-One GoldMine Technical Support ( Fee Based )
www.DJHunt.US
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number

PostPosted: Mon May 14, 2012 12:41 pm Points: 0 Reply with quote
DougCastell
GoldMine Guru
Joined: 15 Jun 2006
Posts: 1639
Location: Los Angeles, CA




I don't recommend you delete anything other than logs and whatnot.

Is your SQL database in SIMPLE mode? right-click on it and go to properties then the option tab in the SQL Management studio tool.

How regularly do your remotes sync? If regularly, you can purge your sync logs, GoldMine transaction logs and system logs to reclaim what can be a significant amount of space.

Do you send out mass e-mail blasts?

_________________
Doug Castell

GoldMine Sales and Support:
http://www.castellcomputers.com/
office: (310)601-4738
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number

PostPosted: Mon May 14, 2012 1:14 pm Points: 0 Reply with quote
bgannett
GoldMine Guru
Joined: 07 Sep 2007
Posts: 1820
Location: Pacific NorthWest




I agree with Doug's comments. What is your full version of your SQL Server to include Service Packs?

Are you having performance issues? If so, please describe them in more detail.

From within GoldMine run the following SQL Query:
Code:
select count(*) from cal where rectype = 'M'

Email performances get quite slow if too many email records are being stored in the CAL table.

You might want to run this query to see if there is a bunch of trash that could be deleted from your mailbox:
Code:
select count(*) from mailbox where folder = 'X-GM-TRASH'

_________________
Bob Gannett
253-627-2244
goldsupport@harbornet.com
*** Providing AFFORDABLE GoldMine Supportsince 1990
View user's profile Send private message

PostPosted: Wed May 16, 2012 1:43 am Points: 0 Reply with quote
ronanc
GoldMine Veteran
Joined: 10 Sep 2007
Posts: 723




The SQL database is made up of two files; the MDF and LDF. Which of these files is 8GB in size?

If the LDF file is large then it means that the transaction log file is not getting cleared down. Set the database recovery mode to Full, and then set the SQL backups to take a full backup once a week, and a transaction log backup nightly. A log backup will clear down the logs and prevent them from growing too large. You may need to do a log backup manually at first, then run a script to shrink the logs down to a smaller size.
View user's profile Send private message

PostPosted: Thu May 17, 2012 12:39 pm Points: 0 Reply with quote
stoessner
GoldMine Journeyman
Joined: 25 Feb 2009
Posts: 46
Location: Ohio




OK apparently I asked the wrong question cause that part is fine. I went thru what you all suggested thank you and all seemed reasonable.

I'm trying to get the data onto a remote machine. The Transfer set is over 8GB and gives me an error of " unable to decrypt transfer set Transfer.gts unable to set end of file %"

this only happens when I try to sync the entire database or when I retrieve a transfer set.

This machine has been one issue after another, I fix one thing then get another error.

Any suggestions on how to get the data to the remote? I've tried to use a filter but for some reason it pulls over all the linked docs whether I ask it to or not with every smaller batch I try.

I know synching will NOT be an issue once I get this main data in there, but until then I'm looking for options!!

Thanks!

_________________
Sally Stoessner
View user's profile Send private message Visit poster's website

PostPosted: Thu May 17, 2012 11:10 pm Points: 0 Reply with quote
bgannett
GoldMine Guru
Joined: 07 Sep 2007
Posts: 1820
Location: Pacific NorthWest




When building the transfer set I would include the links to email attachments and linked document; but I would not include the attachments/documents themselves. If this works, you can copy the attachments and documents separately and place them in the proper place on the receiving system.

_________________
Bob Gannett
253-627-2244
goldsupport@harbornet.com
*** Providing AFFORDABLE GoldMine Supportsince 1990
View user's profile Send private message

PostPosted: Fri May 18, 2012 4:10 am Points: 0 Reply with quote
stoessner
GoldMine Journeyman
Joined: 25 Feb 2009
Posts: 46
Location: Ohio




Thanks Bob, I did try that and still get the error.

another strange thing is that only 2 users come over as well instead of the 5 that there should be.

Last night I started creating filters and that at least seems to be bringing over the data, it just may take a while.

Thanks for your help!!!

_________________
Sally Stoessner
View user's profile Send private message Visit poster's website

GM 7.5 Database issues
  ContactReview Forum Index » GoldMine 7 (Corporate Edition)
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
All times are GMT - 7 Hours  
Page 1 of 1  

  
  
 Post new topic  Reply to topic  


Brought to you by Castell Computers, Doug Castell, Admin
RSS Feed
Powered by phpBB © 2001-2004 phpBB Group
Theme created by Vjacheslav Trushkin