Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Location
    Bogota
    Posts
    8

    Unanswered: [Microsoft][ODBC SQL Server Driver][SQL Server]I/O error (bad page ID)

    Hi!

    Im having this error when doing a query to a SQL Server 2000 Database:

    Microsoft OLE DB Provider for ODBC Drivers error
    '80004005'

    [Microsoft][ODBC SQL Server Driver][SQL Server]I/O error
    (bad page ID) detected during read at offset
    0x000000003ac000 in file 'E:\Program FIles\Microsoft SQL
    Server\MSSQL\Data\sitioIAC_Data.MDF'.

    It doesnt happend in some queryes trough a ASP file.

    What could it be??

    Thank You
    Juan

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Run DBCC CHECKDB against that table(s) with REPAIR_ALLOW_DATA_LOSS option. Refer to BOL for more information on DBCC CHECKDB & CHECKTABLE topics.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •