Respected Sir,
unfortunately hard disk of my system is damaged, now i recovered my database. but it cannot be attached again to SQL management studio 2005.
the error is
myfile.mdf is not a primary database file. (SQL server , error 5171)
plz sir help me...
lois galvezPosted Oct 27, 2014, 12:08 AM
Jackson HewittPosted Aug 4, 2014, 7:09 AM
paula willeyPosted Jul 14, 2014, 2:37 AM
You can try this :- http://www.filesrecoverytool.com/sql-database-repair.html
Ashok SharmaPosted Feb 18, 2014, 1:39 AM
not a primary database file. (Microsoft SQL Server, Error: 5171) ?
The aforementioned error message conveys that the database is corrupt and is, therefore, not accessible.
Cause:
The root cause of this error message is that the database file is corrupt. It may be possible because of various reasons such as power surges, human errors, virus infections, etc.
Resolution:
To address this issue, there are few things that you can perform. First of all, take a backup of this corrupted database lest it is further damaged. Then, you should try to check the database consistency using the DBCC CHECKDB utility. For this, you should run the utility without any clause. The command is executed and the reason for corruption is provided. Then, run the utility using the mentioned clause. However, if you are still not able to repair sql, then you should use a third-party ms sql repair tool for mdf repair. Such tools recover corrupted SQL database components after all kinds of logical crash scenarios.
SQL Recovery software is a robust tool that is used to recover corrupt databases created in MS SQL Server 2000, 2005, and 2008. It is able to repair sql components such as tables, defaults, stored procedures, triggers, views and rules. It can also repair database constraints such as primary key, foreign key, unique key, check, etc. It is a highly interactive tool that does not overwrite the original database while scanning it. It is compatible with Window 7, Vista, 2003 Server, XP, 2000, and NT.
Biswa Pujarini MohapatraPosted Feb 17, 2014, 1:40 PM