August 30, 2016 at 8:18 am
Today I have worked in sql server 2014, I saved all changes in my database and closed it. Couple hours ago I opened it again and showed an error: SQL Server Table Corruption Error. I tried to open it again, but the same error. Is there an effective solution for sql recovery?
August 30, 2016 at 8:26 am
valmostricay (8/30/2016)
Today I have worked in sql server 2014, I saved all changes in my database and closed it. Couple hours ago I opened it again and showed an error: SQL Server Table Corruption Error. I tried to open it again, but the same error. Is there an effective solution for sql recovery?
That does not sound like native SQL Server (because there is no 'save' option there). What program were you working in?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
August 30, 2016 at 8:38 am
valmostricay (8/30/2016)
Is there an effective solution for sql recovery?
Restore from backup, and check your hardware, as corruption is mostly a IO subsystem problem.
That said, I'm curious as to what you're using, because SQL Server doesn't have a 'save all and close' type behaviour.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 31, 2016 at 8:50 am
Thank you guys, for help, unfortunately my problem connected with sql server.
August 31, 2016 at 8:57 am
valmostricay (8/31/2016)
Thank you guys, for help, unfortunately my problem connected with sql server.
As were our replies, whose questions you have not responded to.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
August 31, 2016 at 9:39 am
valmostricay (8/30/2016)
Today I have worked in sql server 2014, I saved all changes in my database and closed it. Couple hours ago I opened it again and showed an error: SQL Server Table Corruption Error. I tried to open it again, but the same error. Is there an effective solution for sql recovery?
If you have any troubles, you can apply solution below or https://repairsql.recoverytoolbox.com/[/url] Recovery Toolbox for SQL Server - 3rd party software for cases, when usual solutions cannot assist.
Start SQL Server Management Studio
Step 1
Click the “Start” button. Move the mouse cursor to the “All Programs” menu, then find and click “Microsoft SQL Server” to open a list of SQL Server programs.
Step 2
Click “SQL Server Management Studio” to open the Connect to Server dialog box.
Step 3
Select a server on your network. Set the “Authentication” pull-down list to “Windows Authentication” and click the “Connect” button.
September 2, 2016 at 4:01 am
This was removed by the editor as SPAM
September 4, 2016 at 10:40 am
Helpful advice man, I will try, but as I think this tool costs money, in my case, I'm ready to pay to get back corrupted data.
September 4, 2016 at 10:55 am
The tool adverts are a common spam here. Mention 'corruption', and you get a pile of them.
We might be able to help more (and maybe even get the data back without you buying dubious and expensive tools), if you could give us more detail on exactly what your setup is. What app, what config, what server setup, that kind of thing.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply