Shelby server crash
Posted on 2011-09-24
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.