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)
Please log in to answer
Posted by:
anonymous_9363
7 years ago
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.
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.