How to Repair Damaged SQL Server 2012 Database?

Question

How to Repair Damaged SQL Server 2012 Database?

tapanikobler

SSC Journeyman

Points: 95
More actions
February 21, 2015 at 11:55 am

#294799

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.
February 23, 2015 at 10:10 pm

This was removed by the editor as SPAM
July 12, 2017 at 11:55 pm

This was removed by the editor as SPAM
September 21, 2018 at 12:51 am

This was removed by the editor as SPAM

Viewing 10 posts - 1 through 9 (of 9 total)

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

pietlinden SSC Guru Points: 63417 More actions · Answer 1

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: 5777 More actions · Answer 2

e4d4

SSCertifiable

Points: 5777

February 22, 2015 at 4:57 am

#1779141

What is exact error message in error log?

Grant Fritchey SSC Guru Points: 398679 More actions · Answer 3

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

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Eirikur Eiriksson SSC Guru Points: 182879 More actions · Answer 4

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

😎

ewoudpauwels SSC Enthusiast Points: 125 More actions · Answer 5

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: 182879 More actions · Answer 6

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.

😎