04-13-2010 11:47 AM
We are running ACT! Premium 2010 on a full install of SQL 2007. For backups we are using the Barracuda Backup which includes a backup agent for SQL. I would also like to backup the database through the ACT! Scheduler. Can I install the scheduler and use it on the SQL server without messing something up with the SQL database?
Also can I manually backup the ACT! database with users logged in?
04-14-2010 01:21 PM
You will not be able to backup the Act! SQL database via an outside backup solution, even with an SQL agent.
Reason is that the Act! database SA password is locked down - i.e. - you do not know what it is (by design - hence the scheduler.)
The recommended way to back up Act! is to use the scheduler. Be sure that you do NOT tell the scheduler to place the resultant backup files in the BACKUP folder in the Act! folders, this is for Act! to use when creating backups - not for human consumption.
Create a plainly identifiable folder - something like 'ScheduledActBackups' or the like - and have the scheduler place it's zip file there.
Then just be sure that the Act! scheduler runs BEFORE your Barracuda Backup scheduler - allow for enough time to complete - and that the Barracuda includes your ScheduledActBackups folder in its process and you are good to go.
04-15-2010 04:46 AM
So how do I install the scheduler? When I try to run it, I get the message that it is not installed.
I am planning to upgrade to ACT! 2010 sp1 can the scheduler be installed at this time?
04-15-2010 06:06 AM
The Act! Scheduler program is installed at the time of the normal Act! install, it isn't a separate install. There are 2 ways to access it: 1. from the Act! Tools menu and 2. from the Windows 'All Programs' list.
Can you give us the exact message you are receiving when you try to start the Scheduler?
What is the operating system you are running?
04-15-2010 07:16 AM
The error is "ACT! Scheduler service is unavailable. Please install the service to run scheduler."
It is installed on Windows Server 2008 R2 Enterprise
Since I do not have experience with SQL we paid someone to install through Sage support. So I don't have a lot of information about the install itself.
04-15-2010 07:28 AM
04-15-2010 07:58 AM - edited 04-15-2010 08:00 AM
Before recommending that you uninstall/reinstall Act! (SQL can be left in place), I'd like for you to see if the Act! Scheduler service is listed in the Startup menu in the System Configuration Utility (Start > Search > MSCONFIG). On the Startup tab there should be an entry for 'Act' with the command "c:\program files\act\act for windows\Act.Scheduler.UI.exe" -Dfalse
Is this in the list and is it 'checked' to enable it?
Also look on the Services tab for 'Act! Scheduler' and ensure that it is checked.
04-15-2010 08:11 AM
At this point I would recommend uninstalling Act! (through Control Panel > Programs and Features), reboot, then reinstall Act!.
The uninstall will not affect the SQL install or Act!'s instance.