Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2015

    Unanswered: I have corrupt DB and I'm trying to restore its .BAK file to a DB with the same name.

    OK, So I have a corrupt DB in MS SQL Server 2005. I cant load it, so I cant restore to it. I created a DB with its same name. I am pulling down the most recent .BAK file for the corrupt DB, hoping it will allow me to restore it to the new DB. Is this possible or do I need to do something else? Help...

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    Yes you can restore a database in SQL 2005, whether it is corrupt or not.

    If you use Transact-SQL, be sure to use the WITH REPLACE option. If you use the GUI be sure to check the REPLACE option. I think that this is in a second tab within the GUI, but I don't use the GUI often enough to be sure.

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

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