Community
Showing results for 
Search instead for 
Do you mean 
Reply

Databases Status RECOVERY_PENDING

New Member
Posts: 3
Country: USA

Databases Status RECOVERY_PENDING

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.

Copper Elite Contributor
Posts: 144
Country: Australia

Re: Databases Status RECOVERY_PENDING

Hi Topaz,

Sorry, I don't have a suggestion for the issue you are having, however, if you would like to look up those KB articles, the url should have a 5 digit KB number on it (e.g. 28393) if you go to kb.swiftpage.com, you will be able to view the same KB.

Hope this helps
Jared Dalrymple | Technical Consultant | P:+61 7 3423 3551
jared@evolutionmarketing.com.au | Evolution Marketing Services


New Member
Posts: 3
Country: USA

Re: Databases Status RECOVERY_PENDING

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.

Copper Elite Contributor
Posts: 144
Country: Australia

Re: Databases Status RECOVERY_PENDING

Thanks for updating us with the KB article Topaz!
Jared Dalrymple | Technical Consultant | P:+61 7 3423 3551
jared@evolutionmarketing.com.au | Evolution Marketing Services


Copper Contributor
Posts: 26
Country: Switzerland

Re: Databases Status RECOVERY_PENDING

When I was looking how to resolve a customer databse with RECOVERY_PENDING, I found a much simpler procedure than listed in article 17715:

 

  1. Start SQL Server Management Studio
  2. Expand the databases
  3. Use Control+N to start a new SQL query window
  4. Type in the follwing Transact SQL code (replace all RecoveryPendingModeDB with the Act! database name and execute the query
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

 

Stefan Koehli
ACT! Cerified Consultant
KÖHLI INFORMATIK AG
Administrator
Posts: 4,024
Country: United_Kingdom

Re: Databases Status RECOVERY_PENDING

Thank you for this information Stefan.

We've created a new Knowledgebase article with these steps: http://kb.act.com/app/answers/detail/a_id/38555
This has also been linked at the beginning of KB 17715.