February 21, 2015 at 11:55 am
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 21, 2015 at 1:57 pm
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?
February 22, 2015 at 4:57 am
What is exact error message in error log?
February 22, 2015 at 6:05 am
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
February 22, 2015 at 10:13 am
Further on Grant's, post the full and unedited output of "DBCC CHECKDB(‘DatabaseName’) WITH NO_INFOMSGS, ALL_ERRORMSGS"
😎
February 26, 2015 at 11:35 am
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/%5B/url%5D
August 31, 2016 at 5:18 am
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
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