09-19-2017 01:54 AM
My database has been corrupted, when i try to connect i receive the below error
I have tried to run a repair on the database but as soon as i right click it i get this message
09-19-2017 02:35 AM
DO NOT try to fix this yourself. Call your local ACT! consultant.
Data loss is imminent when trying to fix this in the wrong sequence of actions.
09-19-2017 03:05 AM - edited 09-19-2017 03:10 AM
Before you do anything else.
Stop the SQL service. Copy all the files where your database is stored into a separate folder.
Now start SQL again.
Type ACTDIAG at Type Here and open ACTDIAG
Click on Database, Database Details List.
Can you see a list of databases?
Does your show in the list.
What does it say under Status?
Does it have a value in Size? If the value is 0 I regret that the database may already be beyond repair.
Have you made any backups? If so how long ago?