823 Error after the DB recovery

I just backup an ArcSDE geography database in SQL Server 2000, whose size is
about 3.5GB. The backup process was finished and checked properly, but when
it has been recovered, some errors occur:
First, when you click the data table in the enterprise manager window,
choose the design item in the right button menu, an error window come to
show: "823" and nothing. And if you choose to see all lines in the table,
you will find some data of the table has disappeared. In other words, data
recovery was not successful, but why no error in the whole process?
Second, if you click some table occasionally, it alerts: The data base has
not been connected.
Third, you can't get connection to the database in any way.
I wonder if there was something wrong underlying, our goal is to move the
database from their machine to ours, and the software environment (I mean
the SQL Server version) is totally the same. Nonetheless, we can not assure
some login users' consistence, which we are going to solve after the
recovery, but we don't take it as the critical reason for the fault.
Therefore, if some veteran in this field can offer some help, I really
appreciate.
Thanks in advance.
error 823 is I/O error %ls detected during %S_MSG at offset %#016I64x in
file '%ls'.
Do you get an error like this or merely 823? What happens when you do a dbcc
checkalloc in this database?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Alex Dai" <alexdaichn@.hotmail.com> wrote in message
news:%235b1J6WVFHA.4056@.TK2MSFTNGP15.phx.gbl...
> I just backup an ArcSDE geography database in SQL Server 2000, whose size
is
> about 3.5GB. The backup process was finished and checked properly, but
when
> it has been recovered, some errors occur:
> First, when you click the data table in the enterprise manager window,
> choose the design item in the right button menu, an error window come to
> show: "823" and nothing. And if you choose to see all lines in the table,
> you will find some data of the table has disappeared. In other words, data
> recovery was not successful, but why no error in the whole process?
> Second, if you click some table occasionally, it alerts: The data base has
> not been connected.
> Third, you can't get connection to the database in any way.
> I wonder if there was something wrong underlying, our goal is to move the
> database from their machine to ours, and the software environment (I mean
> the SQL Server version) is totally the same. Nonetheless, we can not
assure
> some login users' consistence, which we are going to solve after the
> recovery, but we don't take it as the critical reason for the fault.
> Therefore, if some veteran in this field can offer some help, I really
> appreciate.
> Thanks in advance.
>
|||Here I run DBCC CHECKDB('<mydb>', REPAIR_REBUILD), but it informs me the
database must be in single user mode, what's the problem?
"Hilary Cotter" <hilary.cotter@.gmail.com> д?
news:e$Xs42YVFHA.3280@.TK2MSFTNGP09.phx.gbl...
> error 823 is I/O error %ls detected during %S_MSG at offset %#016I64x in
> file '%ls'.
> Do you get an error like this or merely 823? What happens when you do a
dbcc[vbcol=seagreen]
> checkalloc in this database?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Alex Dai" <alexdaichn@.hotmail.com> wrote in message
> news:%235b1J6WVFHA.4056@.TK2MSFTNGP15.phx.gbl...
size[vbcol=seagreen]
> is
> when
table,[vbcol=seagreen]
data[vbcol=seagreen]
has[vbcol=seagreen]
the[vbcol=seagreen]
mean
> assure
>
|||I have been waiting for this issue, somebody could help me out?
"Alex Dai" <alexdaichn@.hotmail.com> д?
news:ODg9OrdVFHA.3076@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> Here I run DBCC CHECKDB('<mydb>', REPAIR_REBUILD), but it informs me the
> database must be in single user mode, what's the problem?
> "Hilary Cotter" <hilary.cotter@.gmail.com> д?
> news:e$Xs42YVFHA.3280@.TK2MSFTNGP09.phx.gbl...
> dbcc
> size
to
> table,
> data
> has
> the
> mean
>