Sage ACT Backup Error

sglee
sglee used Ask the Experts™
on
Hi,
 
 There is an error (please see attached) when trying to backup the database.
 Version 2009 (11.0)
 I ran Database Tools/Maintenance/Check & Repair and it ran successfully without an error.

 I appreciate your solution in advance.
ACT-Backup-Error.doc
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Meir RivkinFull stack Software Engineer
Commented:
also check Paul Randal's post here:
http://social.msdn.microsoft.com/Forums/en-US/sqldisasterrecovery/thread/d9a8bd3b-017c-4ff9-b26c-71402c70bfe6/

both offers to recreate the database since msdb cannot be put into emergency mode so i'll start with that.

Author

Commented:
Have you ran into the above error personally using Sage ACT Software and resolved the problem using above methods?
Exploring ASP.NET Core: Fundamentals

Learn to build web apps and services, IoT apps, and mobile backends by covering the fundamentals of ASP.NET Core and  exploring the core foundations for app libraries.

Meir RivkinFull stack Software Engineer

Commented:
nope.

Author

Commented:
I have found a quite a few articles when I googled it. But I would like try proven method in SAGE ACT environment.
Meir RivkinFull stack Software Engineer

Commented:
fair enough, good luck :)

Author

Commented:
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.
Meir RivkinFull stack Software Engineer

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

Author

Commented:
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.
Meir RivkinFull stack Software Engineer

Commented:
note that it was applied on SQL Server 2005 Express

Author

Commented:
Noted.

Author

Commented:
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?
Mike LazarusAct! Evangelist - CRM Consultant

Commented:
Have you tried running the repair options in ACTDIAG

Author

Commented:
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
Mike LazarusAct! Evangelist - CRM Consultant

Commented:
And you can start ACT!?

Author

Commented:
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.

Author

Commented:
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.

Author

Commented:
Sorry, I forgot to attache the file. Here it is.
Data-Folder.doc
Mike LazarusAct! Evangelist - CRM Consultant

Commented:
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

Author

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

Author

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

Author

Commented:
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?
Mike LazarusAct! Evangelist - CRM Consultant
Commented:
That link was to show a better way to post the errors rather then embedding them in a Word doc.

You can't copy a SQL database while the service is running

The Users folder in windows adds some security that can cause issues.
Best to create a folder c:\ACTData
Stop the SQL ACT7 Instance (via services.msc)
Copy the ADF/ALF and DatabaseFiles folder ... DO NOT copy the PAD file
Start the SQL ACT7 Instance
Open ACT! - File Open
Change File type to ADF and open it
That will check the database and create a new PAD file
Commented:
I ended up buying a upgrade to V2012 (Currenty Version 2009) from Sage becuaes it would come with techinical support. I copied the database except PAD file and database folder to the new computer.
Installed the new ACT V2012 and open the database file and it went thru the conversion process on its own. All is working now.

Thanks for you help.
Mike LazarusAct! Evangelist - CRM Consultant

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

Author

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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial