/build/static/layout/Breadcrumb_cap_w.png

no one knows a reason

I have SQL Server 2005 on my pc. Today .mdf file hasn’t opened: Corruption on non-clustered indexes. I am at loss what to do. Is there a method how to restore .mdf file in sql server 2005?


0 Comments   [ + ] Show comments

Answers (1)

Posted by: anonymous_9363 7 years ago
Red Belt
3
Easy. Just restore from your last back-up. You'll lose some data, obviously, but "most" is better than "none", right?

You have a back-up, don't you? Oh dear... Well, Google "DBCC CHECKDB" in the meantime and then, while that's running, you can research how to back-up SQL Server databases.

BTW, you'll probably find that mentioning your *actual problem* in the 'Subject' box yields better results. What you've put is utterly meaningless.
 
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