Scheduled Backup Problem "Failed to log into the database."

[mrobbins]

I'm having trouble scheduling a backup.

I'm sure it's a simple error.

TIA,

Sage ACT! Premium 2011 Version 13.1.111.0, Hot Fix 4

========SCHEDULER SESSION - 2011-06-23T15:00:11 ========

Start Date/Time: 2011-06-23T15:00:00

Database: myDB

User Name: my

Machine Name: \\PC

Type of Event: Backup with Attachments.

Task Frequency: Between 7:00 AM and 11:00 PM every 2 hours

Result: Task Not Completed

Errors: Failed to log into the database.

Access to the path 'C:\...\myDB-database files\Attachments\Act-Notes.csv' is denied.

Backup Filename and Path: C:\...\ACT! myDB.zip

[jonmklub]

1) have you changed yoru ACT password recently?

2) can you back up manually?

3) are you backing up locally or accross a network. Does it work locally?

4) check permissions

5) is anyone in the database that might have a file opened?

[mrobbins]

Thank you for your time and experience.

1) have you changed yoru ACT password recently?

No.

2) can you back up manually?

Yes.

3) are you backing up locally or accross a network. Does it work locally?

It is a simple local, single-user database.

4) check permissions

Please be more specific.

5) is anyone in the database that might have a file opened?

No.

[gmartin]

Try deleting the current backup task and create a new one.

[mrobbins]

Dear Mr. Martin,

Same error.

[rkumar]

The error message in the log you supplied is:

Access to the path 'C:\...\myDB-database files\Attachments\Act-Notes.csv' is denied.

The first thing to try is copy that file elsewhere, and delete it from where it currently is, and try doing a backup again.

Also, you should delete all tasks from the ACT! scheduler, rightclick on it, and Run As Administrator. Stop the service, start it up again, then create a task. That should fix it.

[mrobbins]

Thank you.

> The first thing to try is copy that file elsewhere, and delete it from where it currently is, and try doing a backup again.

> Also, you should delete all tasks from the ACT! scheduler, rightclick on it, and Run As Administrator. Stop the service, start it up again, then create a task. That should fix it.

I tried both, and it just gave me the same error for another attachment file.

[mrobbins]

> The first thing to try is copy that file elsewhere, and delete it from where it currently is, and try doing a backup again.

> Also, you should delete all tasks from the ACT! scheduler, rightclick on it, and Run As Administrator. Stop the service, start it up again, then create a task. That should fix it.

I tried both, and it just gave me the same error for another attachment file.

[jonmklub]

Does the problem exist if you try the demo database? Also, try a file, save copy as and see if the proiblem is in the copy.

[klock]

I noticed you have the backup going every 2 hours...if you change to once a day, do you still see the error?

Kris Lock

[mrobbins]

Thank you.

I de-selected the backup attachments checkbox and the scheduled backup worked, so the problem is with the attachments.

Does this help?  Do you have any ideas about that?