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.