06-13-2011 02:58 AM
When I try to browse to the Act database (which has been working without a problem for many months) I get a message that 'This Database cannot be opened because the SQLserver version of this database cannot be identified'.
Same thing if I try to browse to the PAD file or direct to the ADF.
If I try to attach the database (I don't know why it has been detached, the setup is that of a client of mine and nobody is aware of having done anything to remove the database......) via Actdiag I get a message that 'The database was created with a version of SQL server which is neither SQL server 2005 or SQL server 2008. Attaching a non SQL 2005 or 2008 database is not supported'
This database was created on this machine with this version of Act.
I can get into Demodata, and create a new database & close & reopen it with no problems or errors, so I'm thinking the problem is with the database itself but without being able to reattach it or open it I can't see how I can get any further?
Act is version 12.0.409.0 Hf1 (2010)
Machine is XP pro.
Any help greatly appreciated.
06-13-2011 04:53 AM
Using ACTDIAG, have you tried the rebuild options? such as rebuild schema and the others?
Since you take daily backups using ACT!, have you tried the restore database option or "restore as" option?
Cheers - FSB
06-14-2011 04:22 AM
Thanks for the suggestions but I don't think I can access any of the rebuild options as the database isn't attached so doesn't appear in the list? If there is a way to do this I'll certainly try it.
I think we will need to resort to a backup but unfortunately this is not a regular client and their backup routine is not as frequent as it should be so was trying to find a way to access without having to do this!
06-14-2011 06:01 AM - edited 06-14-2011 06:09 AM
What about performing a system restore point to a date when things where last working?
As you are attempting recovery, below are some backup processes you may find useful - Cheers - FSB
Open System by clicking the Start button , clicking Control Panel, clicking System and Maintenance, and then clicking System.
In the left pane, click System Protection If you are prompted for an administrator password or confirmation, type the password or provide confirmation.
Click the System Protection tab, and then click Create.
In the System Protection dialog box, type a description, and then click Create.
12-01-2018 11:00 AM
This is the same exact error we are dealing with and wanted to see if anyone had anyone had any luck?
We have not a true backup but a copy of the ADF and ALF files from before when this error happened.
12-01-2018 11:10 AM - edited 12-01-2018 11:11 AM
Sorry, you have not provided enough information for me or anyone to provide a correct response.
What version of act! are you using? reference help about and include the full version info.
Do you have a specific error message? What exactly does it say?
Are you trying to upgrade from some previous version of ACT! yet unbeknownst to us?
and are you trying to upgrade that older vers to the newest version 21? pro? premium? prem for web? etc..
Tip#1= most important for any and all act! users.
Backup your ACT! database Everyday. - from ACT! / File / Backup / Database etc...
Also backup your personal files daily.
12-01-2018 11:25 AM
I posted this message in another thread but I followed up on this thread because it is the same issue. This is the information that you should need to hopefully provided some assistance. Thank you in advance.
We have a client that has ACT 2011 on Windows Server 2012 R2. They have somehow managed to damaged all of their ADF files by messing with ACT 2011 and SQL server. We have no idea what was done except that it is not working.
We are getting this error message with all the current database/files:
This database cannot be opened because the SQLServer version of this database cannot be identified.
When we restore backup files from before this issue occurred, we get a dialog box that say it will verify the database. However, the next moment. we get an error message:
The log scan number (1201:656:1) passed the log scan in database 'Sales' is not valid, The error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). ......
We are doing what seems to be endless research and multiple solutions for SQL and/or ACT and nothing seems to be working. Any thoughts or advice?
12-01-2018 12:09 PM - edited 12-01-2018 12:14 PM
OK thanks that is more info but not enough for me yet? but making progress.
So we know it is some version of act! 2011 ( still not sure of full version info?) AGAIN - reference ACT! help about if possible? to get full version info.
example I am currently using Act! Pro Version 22.214.171.124, Hot Fix 3 - Until next week - then I will be using act! vers 21 pro desktop.
Is your client a single user? Multi user with Remote databases?
How many users?
or do multiple users access the same shared db on a single primary pc?
Your last response you indicated that you tried to restore the db from a ACT! Backup of the db and not a copy of some adf file type etc..
I thought you did not have any ACT! db backups? but only alf or adf file type copies?
Are you trying to restore a remote db?
What version of MS Windows is your client running? Windows 7 ? 10? Are all users using same windows pc version
Did one of the pc's get a windows update and the other pc's did not get the same windows updates yet?
Do all pc's involved have the same sql server version? and .net framework version?
Can you open the ACT! 2011 demo db?
This is about over my head but hopefully some other ACC's will chime in on this with their greater expertise?
Regards - Bill
12-01-2018 12:24 PM
The version is Sage ACT! Pro 2011 Version 13.0.401.0.
We can open a test database without any issues.
It is a multi user environment but we are simply just trying to open a file on the server. Nothing is open on any other computers. I am not even sure of the network environment, like I said I just need to be able to open these files.
The back up was just the FILES/data directory. Think of a Carbonite like backup of just the files not a true SQL backup or backup files out of ACT.
Everything is local.
I am not sure what version of Windows the clients are running as I am only working with the server since I just got dropped into the middle of this war zone/project.
12-01-2018 12:51 PM - edited 12-01-2018 12:53 PM
Hopefully this is enough info for a ACC to assist you with now? You may want to put in a Support Call to Swiftpage Support 1st thing Monday am. ?
It may also help to know How many users and have they been using Remote ACT! database environment?
or just everyone remotely accessing the one and only ACT! db located the main pc?
I want to suggest seeing if their is a Windows PC "Restore Point" you can revert back to? To restore the pc itself back to a previous date/time.
That's is all can can do myself - Good luck . -Bill