Reconnecting Primavera Database
Recently we had an issue with our Hyper-V clusters which resulted in some of our VM server corrupted. Luckily there was a backup. If not.. somebody should start updating their CV’s… 🙂
So, one of the affected servers was our Primavera server. So we had to restore it back from backup, the whole VM, and restore back the SQL database.
After restoring the Server and Database, you’ll notice that the SQL services could not be started. So, what you should do is to install or remove your database instance from the Add/Remove Programs and reinstall/recreate the SQL instance.
When recreating the SQL instance, you can use back your previous instance to save you the trouble of going to each Primavera user to repointing the database. I’ve learned it “the hard way”. So, after you read this, it will save you time if you have so many users.