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.
1. We are getting this error message with all the current database/files when we try to open them:
This database cannot be opened because the SQLServer version of this database cannot be identified.
2. When we restore backup files from before this issue occurred and try to open them 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). ......
3. Finally, when we try to attach the file (that the client "messed with") to the database (via ACTDiag) I get this error message:
"The database was created with a version of SQL Server that is neither SQL Server 2005 or Server 2008. Attaching a non-SQL 2005 or 2008 database is not supported." However, I do not believe SQL version about 2008 R2 has been on this machine.
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?