Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004
    Posts
    1

    Unanswered: Recover database

    Hi

    I've had a powerfailure, that resulted in I had to scratch my DB server, I've managed to get all the .mdf and .ldf files from the server. On the new server I get a "Error 823: I/O error (torn page)" when I'm trying to attach the .mdf file to the New server.
    Both the new and the old server is a win2003 with SQL 2000 SP3

    Is there anybody who knows how I can recover the DB?

    /Rune

  2. #2
    Join Date
    May 2003
    Location
    UK
    Posts
    220
    try a restore to a blank database....

Posting Permissions

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