Solved

Shelby server crash

Posted on 2011-09-24
5
311 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 12

Accepted Solution

by:
Deepu Chowdary earned 500 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

Create the perfect environment for any meeting

You might have a modern environment with all sorts of high-tech equipment, but what makes it worthwhile is how you seamlessly bring together the presentation with audio, video and lighting. The ATEN Control System provides integrated control and system automation.

Question has a verified solution.

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

Suggested Solutions

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This article will shed light on the latest trends when it comes to your resume building needs. For far too long, the traditional CV format has monopolized the recruitment market.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …

749 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