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.
| Author |
Topic |
|
gavis
Starting Member
39 Posts |
 Posted - 2009-06-08 : 05:26:08
|
| 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 resort the database has a temp1 : which didnt work2. taking the DB offline and online again : which didnt work3. restarting the server and services : which didnt work4. enabling tcp services when i tried to run a dbcc checkdbserver : msg 8966, level 16could not read and latch page (1:954) with latch type SH. sysindexes failed.please contact you system administrator.any help would be appreciated |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2009-06-08 : 09:24:37
|
| You should probably post this in the data corruption forum instead. There are some pretty qualified people monitoring it, one of which authored DBCC CHECKDB (Paul Randal)...- Lumbago |
 |
|
|
|
|
|
error 0: this server has been disconnected