| GM 7.5 Database issues | |
Posted: Mon May 14, 2012 9:01 am |
Points: 0 |
|
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 |
|
|
|
| | |
Posted: Mon May 14, 2012 11:57 am |
Points: 0 |
|
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 |
|
|
|
| | |
Posted: Mon May 14, 2012 12:41 pm |
Points: 0 |
|
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? |
|
|
|
|
| | |
Posted: Mon May 14, 2012 1:14 pm |
Points: 0 |
|
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' |
|
|
|
|
|
| | |
Posted: Wed May 16, 2012 1:43 am |
Points: 0 |
|
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. |
|
|
|
|
| | |
Posted: Thu May 17, 2012 12:39 pm |
Points: 0 |
|
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 |
|
|
|
| | |
Posted: Thu May 17, 2012 11:10 pm |
Points: 0 |
|
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. |
|
|
|
|
Posted: Fri May 18, 2012 4:10 am |
Points: 0 |
|
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 |
|
|
|
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
|
|
|
Brought to you by Castell Computers, Doug Castell, Admin
Powered by phpBB © 2001-2004 phpBB Group Theme created by Vjacheslav Trushkin
|