How to Repair Damaged SQL Server 2012 Database?

  • tapanikobler

    SSC Journeyman

    Points: 85

    Something happened with my sql database.

    Due to an unexpected reason sql server database has become corrupted. But don't know how to do fix this.

    Please someone provide me any solution.

  • pietlinden

    SSC Guru

    Points: 62347

    not near enough information to help. How old is your latest backup? Do you have your transaction logs somewhere? what recovery model are you using?

  • e4d4

    SSCertifiable

    Points: 5751

    What is exact error message in error log?

  • Grant Fritchey

    SSC Guru

    Points: 395230

    Run DBCC CHECKDB.

    The output will tell you what is corrupted. If you're lucky, it's a nonclustered index. You can drop it and recreate it and walk away a winner. If it's any other type of data storage, you'll need to go to your last good backup.

    ----------------------------------------------------
    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
    Theodore Roosevelt

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

  • Eirikur Eiriksson

    SSC Guru

    Points: 182321

    Further on Grant's, post the full and unedited output of "DBCC CHECKDB(‘DatabaseName’) WITH NO_INFOMSGS, ALL_ERRORMSGS"

    😎

  • ewoudpauwels

    SSC Enthusiast

    Points: 125

    tapanikobler (2/21/2015)


    Something happened with my sql database.

    Due to an unexpected reason sql server database has become corrupted. But don't know how to do fix this.

    Please someone provide me any solution.

    As a proper variant, visit: http://www.filerepairforum.com/forum/microsoft/microsoft-aa/sql-server/1413-sql-database-in-suspect-mode

    OR

    One more solution is using third-party tools, SQL Server Repair Toolbox is one of the best solution.

    I can recommend it you but check it by running its demo version- http://www.sqlserver.repairtoolbox.com/[/url]

  • Eirikur Eiriksson

    SSC Guru

    Points: 182321

    rodickwillision (8/31/2016)


    To repair corrupt or damaged SQL server database, download an excellent tool Kernel for SQL Database Recovery Tool. The tool also recovers all tables, stored procedure, functions, views, rules, triggers and associated Primary Key, Unique keys and etc. It supports all versions of MS SQL server like 2014, 2012, 2008 R2, 2008, 2005 & 2000 and all updated Windows OS versions. Visit here - http://www.sql.mdfrepair.net[/quote%5D

    It is very irresponsible to suggest any tools for a job when the actual problem is unknown, strongly advise anyone reading this thread to approach such quick fix solutions as suggested here with the utter most caution.

    😎

Viewing 7 posts - 1 through 7 (of 7 total)

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