Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to resolve error while attach MDF file Error (5171) Expand / Collapse
Author
Message
Posted Friday, November 02, 2012 9:48 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, October 02, 2013 10:20 PM
Points: 421, Visits: 87
While i try to attach the mdf file i got the error,

The Error is: DatabaseName.mdf is not SQL Server Database Primary Data File

The SQL server Error No. 5171
Post #1380469
Posted Friday, November 02, 2012 11:12 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, November 19, 2013 2:23 PM
Points: 25, Visits: 118
Hi,

It could be corrupted. Try restoring from a full backup.

Regards
Satyen
Post #1380520
Posted Saturday, November 03, 2012 2:16 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 11:52 AM
Points: 41,530, Visits: 34,446
Restore from a full database backup


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1380677
Posted Sunday, November 25, 2012 11:18 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 05, 2012 12:06 AM
Points: 4, Visits: 3
I found this website on the Google would be work for you. This website offering a free trial version of software, in trial version you can see the preview of recovered data.
http://www.repairsqlserver.net/

Thanks
Post #1388436
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse