12-26-2008 03:08 PM - edited 03-18-2019 10:12 PM
It seems SQL is corrupt after a failed raid on my server. I cannot get SQL to start, it just hangs. Can I reinstall SQL without starting from scratch? Will it overright the database at that point? DIRT restore at that point? Any suggestions would be great.
12-30-2008 11:26 AM
Hi -
Here are my thoughts with the caveat that I would contact Cisco TAC to validate. Did you lose SQL the application or the databases as well? If the databases appear intact, I recommend taking a backup, including the default Microsoft Dbs. I have not experienced a complete catastrophic SQL failure, but have lost the UnityDb database before due to a failed SQL patch. In this case, I had been taking nightly SQL backups of my UnityDb. Working with Cisco TAC and OSQL commands, we disconnected UnityDb from SQL. We restored UnityDb from backup and then reconnected UnityDb using OSQL. This really saved me!!
Ginger
12-30-2008 11:33 AM
I was able to reinstall SQL MSDE and restore from a backup of the UnityDB. The only issue that I incurred was that the location reference in the Subscribers and the main DB did not match the server for some reason. I worked with TAC and they basically got a hex value from the SQL database and copied to the long hex value under the active voice key in regedit. These two varied slightly. You will know you have this issue because you will get a page not displayed when you click on the location, you will also get an error of cannot find the location when you try to bring up a subscriber. Since the customer had not ever had a DIRT backup this was the best case scenerio and I got lucky. Of course they have nightly recurring DIRT setup now!
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide