SQL 2000 Enterprise manager hangs when trying to expand Databases folder tree...
Posted on 2013-01-20
Running SQL 2000 SP4 on Windows 2003 box and was upgrading hard drives on array 2 (databases DBF data files) with OS and SQL install on the other array with SQL LDF log files.
I imaged partitions and restored using an imaging utility.
The restore was VERY long but worked. I had a concern with DRIVE MAPPING as the utility showed my partitions drive letters as DIFFERENT from originals.
I'm aware that if the original drive letters are not the same, that ALL the SQL databases will go into a "SUSPECT" state as they cannot find their MDF or LDF file at specified paths and sometimes DO NOT come back to life.
The plan was to boot into SAFE MODE to make sure SQL services did not run so I could check the drive mappings from the actual OS.
When attempting to boot into safe mode, I missed the F8 boot menu and in a panic I did a hard shut down.
I rebooted, caught the F8 menu, got into safe mode, all the drive letter were correct.
I booted into normal OS.
I run ENTERPRISE MANAGER, it loads, but when I click on the DATABASES FOLDER, I get an hour glass and it does not expand to show my databases. (all other folders, like DTS, managment, etc all open ok)
It's hung and I close it with TASK MANAGER and get a MMC.exe error in the log.
I tried to access the databases and I CAN access them with applications however they seem a little slow. I managed open QUERY ANALYZER and checked the status of all the DB's there and they all show as ONLINE.
I tried to switch ODBC on a workstation to a different database, however ODBC hangs at the authentication page.
Does anyone have any idea whats gone wrong here?