Re: Error SQL 7.0

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 06/02/04


Date: Wed, 2 Jun 2004 22:15:12 +0200

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


Relevant Pages

  • Re: Bulk Import with header in text file
    ... and there is no way to specify a footer or a header. ... The one exception is when you can hide the header in the format somehow. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Questions/Problems with database-driven forms
    ... SQL server database. ... sql server view as a tableadapter, GenerateDBDirectMethods is false, ... I have added two BindingNavigators to the form, ... for the header record which allows traversal between headers, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Query training -- Complex queries
    ... > Update PositionsEOM ... Here you don't have a derived table, but a correlated subquery. ... UPDATE in Books Online. ... is not written for SQL Server. ...
    (microsoft.public.sqlserver.server)
  • Re: Linked Server: How to check if server exists?
    ... The root problem is described in the Books Online topic Batches. ... Rick Byham, SQL Server Books Online ... linked server don't run on those development machines not having that linked ...
    (microsoft.public.sqlserver.connect)
  • Re: STORED PROCEDURE - passing table name as a parameter
    ... T-SQL, is that you get problems if the view definition does not fit into ... will need to query other system tables, for instance syscolumns. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)