question

Shoalox53 avatar image
Shoalox53 asked

Sql 2005 database is crashed

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...
sql database
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

I hope one of methods must assist
0 Likes 0 ·
slackopr avatar image
slackopr answered
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][1]. Because even its demo version showed all the features of it [1]: https://www.repairtoolbox.com/sqlserverrepair.html
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

JohnM avatar image
JohnM answered
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.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

jason_clark03 avatar image
jason_clark03 answered
sometimes this error comes when some one has run a complex UPDATE statement together with a NOLOCK hint against a table in SQL Server. For 2008 and upper virsion microsoft provide a tool to fix this error.You may check this blog which may help you for solving your issue: http://sqlblog.com/blogs/damian_widera/archive/2016/10/24/technical-review-systools-sql-recovery.aspx I
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

DazyParker avatar image
DazyParker answered
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.