Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Location
    Los Angeles
    Posts
    6

    Red face Unanswered: Sql 7.0 Restore From Tape Error

    I got the following error message when trying to restore from tape my entire database. Does anyone know why or how to fix it so I can restore the data?

    "I/O error (bad page ID) detected during read of BUF pointer = 0x148f9880, page ptr = 0x22f44000, pageid = (0x1:0x219fcb), dbid = 9, status = 0x801, file = C:\database\data\orgaddos.mdf"

    Please help.

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    That means TAPE has issues to read the file, also make sure to run DBCC checks against the database take complete backup and then restore.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Jul 2003
    Location
    Los Angeles
    Posts
    6
    Thanks for the info. I found that I was trying to restore a SQL 2000 tape to a 7.0 database. I handled this by installing the SQL 2000 Eval copy and then restored from the tape and it worked fine.
    Thanks again.

Posting Permissions

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