Friday, February 17, 2012

Error SQL 7.0

Hi,
I got this error in the error log:
2004-05-30 06:58:23.85 spid6 Table Corrupt: Object ID 0, index ID 0, page ID (1:1074103). The PageId in the page header = (0:0).
2004-05-30 06:58:24.54 spid6 Error: 823, Severity: 24, State: 1
2004-05-30 06:58:24.54 spid6 I/O error (bad page ID) detected during read of BUF pointer = 0x11efe2c0, page ptr = 0x2d016000, pageid = (0x1:0x1063b7), dbid = 9, status = 0x801, file = e:\MSSQL7\data\pruebas_Data.MDF..
2
2004-06-01 22:04:15.15 spid6 Table Corrupt: Object ID 0, index ID 0, page ID (1:76799). The PageId in the page header = (0:0).
Does anyone can tell me what that it means? Or if it is important and the way to solve
The engine has not service packs intalled
Thanks in advance
this is normally indicative of data corruption due to some hardware or
driver problem with the I/O subsystem as per below. Also would recommend
upgrading to Service Pack 4 for SQL Server
http://msdn.microsoft.com/library/de...err_1_2a0j.asp
more articles.
http://search.microsoft.com/search/r...u=Error%3a+823
Andy.
"Lomu" <anonymous@.discussions.microsoft.com> wrote in message
news:1D80669D-95F6-4903-9447-63DEB80DEDD1@.microsoft.com...
> Hi,
> I got this error in the error log:
> 2004-05-30 06:58:23.85 spid6 Table Corrupt: Object ID 0, index ID 0,
page ID (1:1074103). The PageId in the page header = (0:0).
> 2004-05-30 06:58:24.54 spid6 Error: 823, Severity: 24, State: 1
> 2004-05-30 06:58:24.54 spid6 I/O error (bad page ID) detected during
read of BUF pointer = 0x11efe2c0, page ptr = 0x2d016000, pageid =
(0x1:0x1063b7), dbid = 9, status = 0x801, file =
e:\MSSQL7\data\pruebas_Data.MDF..
> 2
>
> 2004-06-01 22:04:15.15 spid6 Table Corrupt: Object ID 0, index ID 0, page
ID (1:76799). The PageId in the page header = (0:0).
> Does anyone can tell me what that it means? Or if it is important and the
way to solve
> The engine has not service packs intalled
> Thanks in advance
|||I suggest you download and install the latest update for SQL Server 2000 Books Online. It has details
suggestions for most of the corruption errors. I know you are on 7.0, but these things applies. Also, you
might want to read below article:
http://tibdell/SQLServer/info_corrupt_suspect_db.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Lomu" <anonymous@.discussions.microsoft.com> wrote in message
news:1D80669D-95F6-4903-9447-63DEB80DEDD1@.microsoft.com...
> Hi,
> I got this error in the error log:
> 2004-05-30 06:58:23.85 spid6 Table Corrupt: Object ID 0, index ID 0, page ID (1:1074103). The PageId in
the page header = (0:0).
> 2004-05-30 06:58:24.54 spid6 Error: 823, Severity: 24, State: 1
> 2004-05-30 06:58:24.54 spid6 I/O error (bad page ID) detected during read of BUF pointer = 0x11efe2c0,
page ptr = 0x2d016000, pageid = (0x1:0x1063b7), dbid = 9, status = 0x801, file =
e:\MSSQL7\data\pruebas_Data.MDF..
> 2
>
> 2004-06-01 22:04:15.15 spid6 Table Corrupt: Object ID 0, index ID 0, page ID (1:76799). The PageId in the
page header = (0:0).
> Does anyone can tell me what that it means? Or if it is important and the way to solve
> The engine has not service packs intalled
> Thanks in advance

No comments:

Post a Comment