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 wa
y to solve
The engine has not service packs intalled
Thanks in advancethis 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
serr_1_2a0j.asp" target="_blank">http://msdn.microsoft.com/library/d...serr_1_2a0j.asp
more articles.
823" target="_blank">http://search.microsoft.com/search/...%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 Boo
ks Online. It has details
suggestions for most of the corruption errors. I know you are on 7.0, but th
ese 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 BU
F pointer = 0x11efe2c0,
page ptr = 0x2d016000, pageid = (0x1:0x1063b7), dbid = 9, status = 0x801, fi
le =
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:76
799). 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