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
   

- Advertisement -