/build/static/layout/Breadcrumb_cap_w.png

Software Question


no one knows a reason

04/25/2017 576 views

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

Comments



Community Chosen Answer

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.
Answered 04/26/2017 by: VBScab
Red Belt

All Answers

This content is currently hidden from public view.
Reason: Junk 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