Sage ACT Backup Error

Have you ran into the above error personally using Sage ACT Software and resolved the problem using above methods?

nope.

I have found a quite a few articles when I googled it. But I would like try proven method in SAGE ACT environment.

fair enough, good luck :)

Thank you for the suggestions. This error is on my customer's ACT and I like to make sure that I try a proven method.

i'll ask around our DBA's to see if they encountered that kind of error, i'll keep u posted.

I found  the following KB article off Sage Support website.

http://kb.sagesoftwareonline.com/app/answers/detail/a_id/24695/kw/backup%20error

As soon as I can access my customer's computer, I will try it and keep you posted.

note that it was applied on SQL Server 2005 Express

Noted.

Well, that did not work.
Copied the master.mdf and msdblog.ldf (extracted from the original CD)to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data. But I could not even start ACT program because "SQL Server (ACT7)" would not event start in Services.msc.
Thank god, I renamed the original master.mdf and msdblog.ldf files for safety. I had to restore them.
Any other suggestions?

Have you tried running the repair options in ACTDIAG

When I type in ACTDIAG from Start/Run, I get an error "Could not connect to the SQL Sesrver Instance. Click Yes to continue anyway, no to restart ActDiag, cancel to close."
When I click "Connect anyway", then ACT Diagnostics windows comes up as seen in atttached.
ActDiag-Error.doc

And you can start ACT!?

Yes I can start ACT and all the data is there and software is fully functional.
The only thing, as seen in my initial description, is that when you do a backup, it generates an error. However the message says that the backup was successfully processed. Please see attached.

I have two questions.
(1) As seen attached, I see multiple ADF files in C:\Users\%UserName%\Documents\ACT\ACT for Windows 11\Databases. Since I am new to ACT, why are so many different files? I think Primary0802.ADF file seems to be open by default whenever I run ACT.
(2) Are the files in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data system files? I replaced existing master.mdf and msdblog.ldf files from the ACT CD (according to the article found in ACT forum) and I could not even open ACT program at all. So I restored the original files and I was able to run ACT at least.

Sorry, I forgot to attache the file. Here it is.
Data-Folder.doc

1. The ADF files are different databases created by you (or someone on the computer)
2. The files are not used by ACT! exclusively. They are part of SQL

Try opening ACTDIAG again ... sometimes, it will fail the first time, then open when you try again

BTW: Please don't attach images in Word files. Much easier to just use Paint

See: http://blog.glcomputing.com.au/2009/05/how-to-get-faster-technical-support-for.html

I tried ActDiag more than once, but it got same result everytime.

GLComputing -
What was the purpose of the following link?
http://blog.glcomputing.com.au/2009/05/how-to-get-faster-technical-support-for.html

OK. I installed the same version of ACT on the new computer and tried to copy database files from old computer to the new computer.
I created a share on the old computer on C:\Uses\Username\Documents\ACT\ACT for Windows 11\Databases folder.
Then I went to the new computer and opened the above folder in windows expolorer. When I tried to copy / paste ADF/ALF/PAD files, it erros with "File Access Denied". You need permission to perform this action. You require permission from the computer's administrator to make changes to this file: Primary0802.ADF"
Do you know why I can't simply copy and paste?

Glad it's working for you ... ACT! 2012 is better at understanding and setting correct permissions automatically

none of the suggestions worked. Sage tech support helped me migrate to a new version of ACT.