Post reply

How to restore invalid SQL 2005 file?

  • February 8, 2015 at 2:27 pm

    #295195

    I have a SQL 2005 .bak file that is corrupted, I was using standard guide restore method. The file size looks correct (2 GB) but it wont restore. Any way to repair this .BAK and see the data?

  • February 9, 2015 at 1:34 am

    #1776302

    What are the errors?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 12, 2015 at 7:26 am

    #1777239

    Hi,

    You may try third party solution Recovery Toolbox for SQL Server

    I can suggest you a good manual solution that will help you repair your corrupt MDF file of SQL Server. DBCC CHECKDB and DBCC DBREPAIR statements have to be executed to perform repair operation.

    The query statements and manual for software are given in this post: https://sql.recoverytoolbox.com/[/url]

    Follow the steps given in this post and execute the DBCC CHECKDB and DBCC DBREPAIR statements as given in the post.

    Thanks.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply