/build/static/layout/Breadcrumb_cap_w.png

database doesn’t open via sql server

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?


0 Comments   [ + ] Show comments

Answers (4)

Answer Summary:
Posted by: excellws 4 years ago
White Belt
1

Top Answer

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/

Posted by: anonymous_9363 4 years ago
Red Belt
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
Posted by: Billywon095 4 years ago
White Belt
0
Great advise dude, many thanks.
Posted by: scottsmith24 4 years ago
Yellow Belt
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

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ