We are running Sharepoint with Microsoft SQL Server on a Windows 2k3 Server. At some point the raid controller failed. After being replaced we found the database was marked "suspect" and will not open. There seem to be three parts to the database: dbname_PROF, dbname_SITE, and dbname_SERV. The logs indicate that only the bdname_SERV is marked "suspect". I have found information on how to reset the suspect status, however, we do not have access to the 'sa' account. The database developer has moved on to another company (and even though was contacted, cannot remeber the account info). Is there a way to access the database - maybe an account recovery mech. or default account - which will allow us to reset the _SERV portion and open the database?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!