Community
Showing results for 
Search instead for 
Do you mean 
Reply

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

Copper Contributor
Posts: 131
Country: USA

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

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

Silver Contributor
Posts: 1,813
Country: USA

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

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?

Test Drive Act! and Quickbooks over Citrix http://GoTryAct.com

Jon Klubnik| ActTrainer.com
(866)710 4228

ACT! Certified Consultant / ACT! Premier Trainer / ACT! Hosting Provider

Copper Contributor
Posts: 131
Country: USA

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

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.

Platinum Super Contributor
Posts: 5,275
Country: USA

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

Try deleting the current backup task and create a new one.
Greg Martin
Sage
Copper Contributor
Posts: 131
Country: USA

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

Dear Mr. Martin,

 

Same error.

Copper Super Contributor
Posts: 78
Country: Australia

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

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.

Copper Contributor
Posts: 131
Country: USA

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

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.

Silver Contributor
Posts: 1,813
Country: USA

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

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.

Test Drive Act! and Quickbooks over Citrix http://GoTryAct.com

Jon Klubnik| ActTrainer.com
(866)710 4228

ACT! Certified Consultant / ACT! Premier Trainer / ACT! Hosting Provider

Copper Elite Contributor
Posts: 336
Country: USA

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

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

Kris Lock
Inside Sales Manager/ACT! Certified Consultant
Technology Transfer Services
www.techtransfer.com
www.myodesie.com
Copper Contributor
Posts: 131
Country: USA

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

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?