I was working on my sql database. But something happened with database and it showed an error msg - Corruption on non-clustered indexes. I opened database again, but I got the same error. I don't know what ways to use sql server database repair ways. Any tips or suggestions...
When you work with sql database during some months and after it becomes invalid. I’m sure every man will waste all the free time for searching reliable solution. I find it in [SQL Server Repair Toolbox]. Because even its demo version showed all the features of it :
What is the error message? If the corruption is really on a non-clustered index you should be able to just re-create the non-clustered index. However, until that can be confirmed from the error message I would be cautious. Make sure you have your backups ready and confirmed. If you can post the error message we should be able to help.