[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Shelby server crash

Posted on 2011-09-24
5
Medium Priority
?
339 Views
Last Modified: 2012-05-12
Hi all,
I had a windows server 2000 crash on me and I've been working on restoring our Shelby server using recovered mdf and bak files but have had no results.  The mdf file I have was not detached properly and is giving me the error: “C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\shelbydb.mdf is not a primary database file. (Microsoft SQL Server, Error: 5171)”.  When I try the .bak files I've been able to retrieve, the new shelby does not recognize them as valid shelby bak files.  So, with this said, does anyone ideas on how I can either 1) fix the mdf file or 2) fix the bak file so that I can get our shelby server up again.  Any help would be greatly appreciated!!  Thank you in advance.
0
Comment
Question by:eddie_madrigal
  • 2
4 Comments
 
LVL 12

Accepted Solution

by:
Deepu Chowdary earned 2000 total points
ID: 36594323
0
 

Author Comment

by:eddie_madrigal
ID: 36594400
Hi Exchange9,
I've tried the attach but because the mdf file I have was never detached, I get a 'not a valid database header' error; I will try:

RESTORE DATABASE shelbydb FROM 'c:\backup\shelby.mdf' WITH RECOVERY

and see what happens.

Thank you.
0
 
LVL 12

Expert Comment

by:Deepu Chowdary
ID: 36594406
Ok :)
0
 
LVL 11

Expert Comment

by:sparab
ID: 37043526
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I originally wrote this article to compare SARDU and YUMI, but have now added Easy2Boot, since that is the one I currently use and find the easiest to create and alter.
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses. Navigate to the “Start Mail Merge” button in the Mailings tab: Follow the step-by-step process until asked to find the address doc…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question