03-03-2014 02:31 PM
I attempted to copy two of my databases to a different computer on my network. Now when I open Act on either computer it prompts me to enter a password and tells me that my databases cannot be accessed. I tried starting, and restarting the SQL services but to no avail. When I go into actdiag, the statuses on both said databases are RECOVERY_PENDING with a size of 0. I did see this issue in another thread post but all of the answers are linked to the Sage KB and they are ALL broken links.
03-03-2014 03:25 PM
03-04-2014 08:08 AM
Problem solved. For future reference, http://kb.swiftpage.com/app/answers/detail/a_id/17715/kw/17715. I know get frustrated when a problem is solved and the solution isn't explained.
03-04-2014 03:22 PM
01-24-2017 07:00 AM
When I was looking how to resolve a customer databse with RECOVERY_PENDING, I found a much simpler procedure than listed in article 17715:
Use [master] EXEC sp_resetstatus RecoveryPendingModeDB ALTER DATABASE RecoveryPendingModeDB SET EMERGENCY DBCC checkdb(RecoveryPendingModeDB) ALTER DATABASE RecoveryPendingModeDB SET SINGLE_USER WITH ROLLBACK IMMEDIATE DBCC CheckDB(RecoveryPendingModeDB,REPAIR_ALLOW_DATA_LOSS) ALTER DATABASE RecoveryPendingModeDB SET MULTI_USER EXEC sp_resetstatus RecoveryPendingModeDB
01-27-2017 01:39 AM