Community
Showing results for 
Search instead for 
Do you mean 
Reply

Using Active Scheduler for an Automated Backup

Accepted Solution Solved
Copper Contributor
Posts: 157
Country: United States
Accepted Solution

Using Active Scheduler for an Automated Backup

I can manually back up the Act 2010 database to a network drive with no problem.

 

I set up an automated backup with the Act scheduler and used the exact same drive and folder as I used in the manual backup, I get the following error:

 

 

Errors: Failed to log into the database. Access to the path '\\P4B\Temp\ACT! Contacts4 7879a33b19a44402a4f2678bed4b91c6 2010-03-08 20-38-00.zip' is denied.

Backup Filename and Path: \\P4B\Temp\ACT! Contacts4.zip

 

Why does the manual backup work fine but the automatic doesn't? 

 


Accepted Solutions
Solution
Accepted by gmartin (Platinum Super Contributor)
‎09-25-2015 03:20 AM
Platinum Elite Contributor
Posts: 6,653
Country: USA

Re: Using Active Scheduler for an Automated Backup

The scheduled backup can't use a mapped drive as the target, it must be a local drive.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129

View solution in original post


All Replies
Solution
Accepted by gmartin (Platinum Super Contributor)
‎09-25-2015 03:20 AM
Platinum Elite Contributor
Posts: 6,653
Country: USA

Re: Using Active Scheduler for an Automated Backup

The scheduled backup can't use a mapped drive as the target, it must be a local drive.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Copper Contributor
Posts: 157
Country: United States

Re: Using Active Scheduler for an Automated Backup

That explains it.

 

Do you think there is a good reason why Act can not backup to a natwork drive or is this a programming oversight?

 

 

Platinum Elite Contributor
Posts: 6,653
Country: USA

Re: Using Active Scheduler for an Automated Backup

This is a guess but I think it's the reason. Because the SQL server has the database files open all the time, many backup programs won't back them up. The scheduler with the backups provides a way to do a backup on the ACT! database before the system backup. To make sure the backup file was in a location where the system backup could find it, the scheduled backup is restricted to a local drive.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Copper Contributor
Posts: 157
Country: United States

Re: Using Active Scheduler for an Automated Backup

I am not sure if I am smart enough to agree or disagree with your guess as to why the Act scheduler cannot backup automatically to a network drive.  

 

I am able to manually back up to the network drive while the program is running. I imagine a short macro may be a workaround that would accomplish a scheduled backup up to a network drive.

 

I use macro express and have currently written hotkey macros for auto dialing, rescheduling etc. I use "alt" 1 through 4 to automatically dial one of four contact phone numbers, and alt d, w, m, and y to reschedule an item in one day, one week, one month and one year.

Platinum Elite Contributor
Posts: 6,653
Country: USA

Re: Using Active Scheduler for an Automated Backup

The ACT! scheduler backup doesn't require the ACT! program to be runing.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Copper Contributor
Posts: 157
Country: United States

Re: Using Active Scheduler for an Automated Backup

The Act scheduler seems unable to backup to a network drive whether Act is running or not. Are you aware of any workaround other than creating a macro to back up the database to a network drive? 
Platinum Elite Contributor
Posts: 6,653
Country: USA

Re: Using Active Scheduler for an Automated Backup

You're right, the scheduler must backup to a local hard drive.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Copper Contributor
Posts: 9
Country: USA

Re: Using Active Scheduler for an Automated Backup

[ Edited ]

I'm also using scheduler for automatic backups and what ACT! creates is a zipped file.  Is this the default?  Does ACT! create its backups as zipped files?  The problem I'm having is that the remote backup system I use for my hard drive seems to have a problem backing up these zipped ACT! backups.  I receive an error message about unauthorized access and I wonder if all might work well if the backups created by ACT! were not zipped.  I'm using Pro 2011 with windows 7 pro and 64 bit.