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. 04-24-2015, 03:00 PM #1
    mutikhoury
    mutikhoury is offline Registered User
    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...
    Reply With Quote Reply With Quote
  2. 04-25-2015, 01:07 PM #2
    rmiao
    rmiao is offline Registered User
    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.
    Reply With Quote Reply With Quote
  3. 05-29-2015, 06:42 AM #3
    sagehickman
    sagehickman is offline Registered User
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules