SQL Server Performance

Emergency! Help needed.

Discussion in 'SQL Server 2005 General DBA Questions' started by RaymondXie, Sep 13, 2007.

  1. RaymondXie New Member

    Hello,
    Ijust have my disk re-imaged, before that, I back up all the data filesfor SQL 2000, now I am trying to bring them back, however, I got errorsaying:
    The file you specified is not a valid sql server database.

    What I did is:
    back up .mdf/ldf files
    attach them after system is re-imaged.

    The only change that might exist is: I applied SP4 after the new image. I might have an earlier version before the re-image.
    Thank you.
  2. Luis Martin Moderator

    Did you dettach or only backup?
  3. RaymondXie New Member

    I stopped the database. I copied all the database files. I did this numerous time.
    I also just uninstalled SQL2005, 2000, and re-installed SQL2000, with the same patch sp3a.
    I'm still getting the same error.
    Crazy! What's going on?
    Thank you very much.
  4. satya.sqldba New Member

    What do you mean by 'stopped the database'?
    Do you have '.bak' files or .mdf,.ldf with you?
    Satya

  5. Luis Martin Moderator

    Did you move mdf and log to different places (from the original once) after reinstall 2000?
  6. RaymondXie New Member

    I have all the mdf and ldf files. I saved the mdf/ldf files after I stopped SQL server. All the files were copied over to the same folder when trying to restore them.
    I've opened a ticket with Microsoft. I'll post their solution here later on.
    Thanks for help.
  7. Luis Martin Moderator

    Thanks for sharing.
  8. RaymondXie New Member

    This is rediculous, MS doesn't have a solution to fix the problem. What they are thinking is the file is corrupted, but I burned not only database files, there are also thousands of files in other formats, only sql files not working now.
    Does anyone have any recommendation?
    Thanks lots.
  9. Luis Martin Moderator

    Sorry to hear that.
    I'm afraid I have no idea how to fix.
    I know you are in troubles, but next time you have to backup also.
  10. ghemant Moderator

Share This Page