02-05-2018 01:42 PM
Running ACT v16 Premium. Attempting to unpack and restore a database, but it wouldn't restore. In ACTDIAG the database was initially listed as SUSPECT, but now says "RECOVERY-PENDING". Trying to detach database, but every time I select the database and click "Actions" I get an error message that says "Unable to cast object of type 'System.DBNull' to type 'System.String'. Have tried manually deleting the files but there was only the ALF file. Also tried stopping ACT 7 instance of SQL. Any suggestions would be greatly appreciated.
02-06-2018 03:01 AM - edited 02-06-2018 03:02 AM
I would recommend restoring from a recent backup if you have one.
If not, then you could try stopping the SQL instance - then physically moving the ADF and ALF files to another location and renaming them. Then restarting the instance and trying to attach them.
Sometimes methods like this will cause open transactions in the log file, which usually will require re-creation. I can provide steps on this if it becomes necessary.
02-06-2018 05:45 AM
What do you mean by "restore from a recent backup"?
I'm a little concerned that the only database file I can find is the ALF. The ADF is no where in sight.
02-06-2018 06:27 AM