Community
Showing results for 
Search instead for 
Do you mean 
Comments
by ksmith
on ‎08-08-2011 04:02 PM
24 databases to back up on the same host? That seems excessive, and unusual. I wonder if you have them scheduled too closely, so that backups can't start because the last database hasn't finished it's backup yet. Particularly if you are including attachments in your backups.
by snakeroot
on ‎08-08-2011 04:08 PM

That was one thought I had too, but if they're backedup in the same order every night, why would some work sometimes and not other times?  Also, I timed the largest database when performing a manual backup, then added 10 min. between databases.  Seems to me that would be adequate.  

by
on ‎08-08-2011 04:18 PM

At very least they should make it notify when it fails - email or an activity created for specified user(s) in ACT!

 

BTW: That many databases, I assume using Premium? Get the sa utility and use a proper SQL backup

 

Actually, I've just been talking to a backup developer... just need to test before saying publicly, but might have a backup solution that doesn't need sa - uses the Windows Admin in SQL Mixed Mode

 

Regards,
Mike Lazarus
ACT! Evangelist
GL Computing, Australia
http://Blog.GLComputing.com.au
http://twitter.com/GLComputing

GL Computing Facebook Page - http://www.facebook.com/GLComputing
LinkedIN ACT! Fanatics Group - http://www.linkedin.com/groups?gid=49896

by snakeroot
on ‎08-08-2011 04:25 PM

Ya, well the sa utility at (last I checked) $1000 is a hard sell when my boss is cursing at Act! every day because it's not doing what he wants and he's threatening to move to some other CRM.  

 

A few versions back, I was able to modify the sql code upon install that gave me sa, but Act! caught on to that pretty quickly and doesn't work anymore.  

 

Interested in hearing about you new backup solution, if it pans out. 

by Copper Elite Contributor
on ‎09-19-2011 01:22 PM

Sounds like you need to space your backup schedule among the databases more.  First, why would you need 24 separate databases?  Sounds like your contact management implementation isn't correct and I bet your databases have more activity that is taking longer to backup such as attachments.  Secondly, if you had Premium and one centralized database you could afford the sa password, or at least hired an ACT consultant to install ACT with manual unstallation and create your own SA. Then you could use backup exec and avoid the backup tool from ACT.

 

If those aren't options you like, you can also look to asdscomputer.com which sells AutoAdmin that can properly backup an ACT database and email you details.

 

hope that helps a little,

Alanna

Labels