Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / DB Engine / SQL Server / July 2008

Tip: Looking for answers? Try searching our database.

MSSQL 2000  backup Error

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
wissam - 02 Jul 2008 09:56 GMT
I have a MSSQL 2000 system on a Windows 2000 server that backups of a
particular database fail.

Nonrecoverable I/O error occurred on file 'd:\data\database.mdf'

and I have enough space on the OUTPUT disk.

I run
DBCC CHECKTABLE on a big table on my database I get these errors

is there any relation?
Server: Msg 8966, Level 16, State 2, Line 1
Could not read and latch page (1:1739600) with latch type UP. 23(Data error
(cyclic redundancy check).) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:1739601) with latch type UP. 23(Data error
(cyclic redundancy check).) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:1739602) with latch type UP. 23(Data error
(cyclic redundancy check).) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:1739603) with latch type UP. 23(Data error
(cyclic redundancy check).) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:1739604) with latch type UP. 23(Data error
(cyclic redundancy check).) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:1739605) with latch type UP. 23(Data error
(cyclic redundancy check).) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:1739606) with latch type UP. 23(Data error
(cyclic redundancy check).) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:1739607) with latch type UP. 23(Data error
(cyclic redundancy check).) failed.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:1739600) allocated to object ID 295672101, index ID 29
was not seen.  Page may be invalid or have incorrect object ID information in
its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 295672101, index ID 29. Page (1:1739600) was not seen
in the scan although its parent (1:1490082) and previous (1:1698663) refer to
it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:1739601) allocated to object ID 295672101, index ID 29
was not seen.  Page may be invalid or have incorrect object ID information in
its header.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 295672101, index ID 29. Index node page (1:1490082),
slot 15 refers to child page (1:1739601) and previous child (1:1739600), but
they were not encountered.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:1739602) allocated to object ID 295672101, index ID 29
was not seen.  Page may be invalid or have incorrect object ID information in
its header.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 295672101, index ID 29. Index node page (1:1490082),
slot 16 refers to child page (1:1739602) and previous child (1:1739601), but
they were not encountered.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:1739603) allocated to object ID 295672101, index ID 29
was not seen.  Page may be invalid or have incorrect object ID information in
its header.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 295672101, index ID 29. Index node page (1:1490082),
slot 17 refers to child page (1:1739603) and previous child (1:1739602), but
they were not encountered.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:1739604) allocated to object ID 295672101, index ID 29
was not seen.  Page may be invalid or have incorrect object ID information in
its header.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 295672101, index ID 29. Index node page (1:1490082),
slot 18 refers to child page (1:1739604) and previous child (1:1739603), but
they were not encountered.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:1739605) allocated to object ID 295672101, index ID 29
was not seen.  Page may be invalid or have incorrect object ID information in
its header.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 295672101, index ID 29. Index node page (1:1490082),
slot 19 refers to child page (1:1739605) and previous child (1:1739604), but
they were not encountered.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:1739606) allocated to object ID 295672101, index ID 29
was not seen.  Page may be invalid or have incorrect object ID information in
its header.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 295672101, index ID 29. Index node page (1:1490082),
slot 20 refers to child page (1:1739606) and previous child (1:1739605), but
they were not encountered.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:1739607) allocated to object ID 295672101, index ID 29
was not seen.  Page may be invalid or have incorrect object ID information in
its header.
CHECKTABLE found 0 allocation errors and 8 consistency errors not associated
with any single object.
DBCC results for 'CDR_tmp'.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 295672101, index ID 29. Index node page (1:1490082),
slot 21 refers to child page (1:1739607) and previous child (1:1739606), but
they were not encountered.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 295672101, index ID 29. Page (1:1743648) is missing a
reference from previous page (1:1739607). Possible chain linkage problem.
There are 5339984 rows in 147986 pages for object 'CDR_tmp'.
CHECKTABLE found 0 allocation errors and 17 consistency errors in table
'CDR_tmp' (object ID 295672101).
repair_allow_data_loss is the minimum repair level for the errors found by
DBCC CHECKTABLE (ViaStarBilling.dbo.CDR_tmp ).
Tibor Karaszi - 02 Jul 2008 10:17 GMT
You have a corruption in your database. I suggest you restore from your most recent clean backup and
possibly also do log restore after that (assuming you did log backups in the first place). To read
general info about database corruptions, Google for Paul Randal.

Signature

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

>I have a MSSQL 2000 system on a Windows 2000 server that backups of a
> particular database fail.
[quoted text clipped - 106 lines]
> repair_allow_data_loss is the minimum repair level for the errors found by
> DBCC CHECKTABLE (ViaStarBilling.dbo.CDR_tmp ).
wissam - 02 Jul 2008 10:23 GMT
Can I fix this corruption on the existing one?

> You have a corruption in your database. I suggest you restore from your most recent clean backup and
> possibly also do log restore after that (assuming you did log backups in the first place). To read
[quoted text clipped - 110 lines]
> > repair_allow_data_loss is the minimum repair level for the errors found by
> > DBCC CHECKTABLE (ViaStarBilling.dbo.CDR_tmp ).
Tibor Karaszi - 02 Jul 2008 11:10 GMT
> Can I fix this corruption on the existing one?

Impossible to tell. We don't have full information to begin with. For that you would run DBCC
CHECKDB (not CHECKTABLE). Then you would read the output and try to understand whatever corruptions
it reports. Based on that you could try to judge what situation you have at hand. CHECKDB does
report lowest repair option (see end of output). It has already now, when executed for only one
table, signaled that repair_allow_data_loss is minimal level - which doesn't look good.

As you might realize, having MS hand-hold you through this process (opening a case with MS Support)
is probably a good idea unless you are very familiar with SQL Server storage structure. Or, restore
from most clean backup...

And don't forget to do root-cause analysis to determine what caused this in the first place - you
don't want this to happen again.

Signature

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

> Can I fix this corruption on the existing one?
>
[quoted text clipped - 114 lines]
>> > repair_allow_data_loss is the minimum repair level for the errors found by
>> > DBCC CHECKTABLE (ViaStarBilling.dbo.CDR_tmp ).
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.