Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  Data Corruption Issues  error 0: this server has been disconnected

Author  Topic  gavis Starting Member 39 Posts Posted - 2009-06-08 : 09:55:44 hi. the client is running sql 2000, the database went into suspect, which i managed to fix and recover now when i click on the database proprieties i get this error "error 0: this server has been disconnected. you must reconnect to perform this operation". i have done the following to try and fix it. 1. backup and restoring the database as a temp1 : which didnt help 2. taking the DB offline and online again : which didnt help 3. restarting the server and services : which didnt help 4. enabling tcp services : which didnt work 5. when i tried to run a dbcc checkdb i got this msg : server : msg 8966, level 16 could not read and latch page (1:954) with latch type SH. sysindexes failed. please contact you system administrator. any help would be appreciated