/build/static/layout/Breadcrumb_cap_w.png

Software Question


database doesn’t open via sql server

01/31/2017 888 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.
 
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