/build/static/layout/Breadcrumb_cap_w.png
01/31/2017 826 views

I was working in SQL Server 2014 for couple hours and I got an error - SQL Server Table Corruption Error. Does someone know a way to repair sql database?

Answer Summary:
0 Comments   [ + ] Show comments

Comments


Answer Chosen by the Author

1

Firstly apply SQL Server Management Studio; usually it resolves most ofproblems. Second variant can be Recovery Toolbox for SQL Server. 


It is only my choice and an advice for you, because application workswith all version of SQL Server and has row of another pluses https://sql.recoverytoolbox.com/

Answered 02/01/2017 by: excellws
White Belt

All Answers

0
Use the back-up you took before you started messing about?

Alternatively, you could use a search engine to find the answer. https://msdn.microsoft.com/en-us/library/ms176064.aspx
Answered 02/01/2017 by: VBScab
Red Belt

0
Great advise dude, many thanks.
Answered 02/01/2017 by: Billywon095
White Belt

This content is currently hidden from public view.
Reason: Removed by member request For more information, visit our FAQ's.
0

As you are saying youhave encountered table corruption issue and not being able to execute yourqueries. There are Sql database recovery commands available which have to beexecuted from within database file. But there are many of these commands, so Icannot tell you which one will work for sure. You can find these commands oninternet. In my opinion after trying out Sql database recovery commands , youcan go for some SQL database recovery tool. I am not saying straight awaypurchase it but first use its free demo version if available and then decide. Ican help you in this regard by giving you one link about a Sql databaserecovery software which has free demo version available.

https://www.sysinfotools.com/recovery/ms-sql-database-recovery.php

Answered 02/03/2017 by: scottsmith24
Yellow Belt

This content is currently hidden from public view.
Reason: Member has been banned from the site banned by admin For more information, visit our FAQ's.