Results 1 to 3 of 3

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

  1. #1
    Join Date
    Apr 2015
    Posts
    1

    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
    Sep 2002
    Posts
    5,938
    Yes, you can restore to different name and check if it looks good. Then you can drop corrupted db and rename restored one.

  3. #3
    Join Date
    May 2015
    Posts
    2
    Data from corrupt mdf file can be recovered by following methods:

    Repair MDF file with DBCC CHECKDB: Microsoft offers a command that is known as DBCC CHECKDB, when you run this then it try to detect & fix all the possible error message. If it fails to fix error message then it suggest repair clause. Re-run the command with suggest repair clause. Your problem might be solved. But, you may loss some amount of data after this.

    A lot of helpful tips there are on...
    http://answers.unity3d.com/questions...-database.html
    http://www.sqlservercentral.com/Foru...448-266-1.aspx

Posting Permissions

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