You’ve lost, or you’ve accidentally deleted ,the Central Administration database from your MOSS or Windows SharePoint Services environment.
Obviously corruptions happen, users get carried away with stsadm, or, in my case, you simply deleted the wrong database and you didn’t have a backup. Luckily for me, I made this mistake in a test environment. Not to worry, there’s any easy fix, see below!
It’s actually quite simple to recover a central administration database if you have another central admin database that exists in the same domain. Simply backup the database from one farm and restore it to the other. If you can’t get your hands on another central admin database you’ll probably be able to get one from a friendly forum user but you might have to modify the UserInfo tables directly in order to get your user information added to the database.
Here’s what I did to recover my accidentally deleted central administration database:
Step 1 – Add a new content database to your existing (but empty) central administration website.
Ulysses Ludwig is a SharePoint architect with over 16 years in the IT and computer industry. Ulysses' primary focus is SharePoint but he dabbles in the latest web technologies and likes to develop software in his spare time.