SQL Database is corrupted....... plz help.

Question

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 galvez · Answer

You can also try another excellent tool which is well known SQL recovery software that recovers and repairs your corrupted or inaccessible SQL database without hassle. For more details about this tool please see this site:- http://www.pcrecoveryutility.com/sql-database-recovery.html

Jackson Hewitt · Answer

Yes sure defiantly I have help you regarding of SQL database corruption and easily repair and recovery MDF file from corrupt and damaged SQL server. Visit here: http://www.en.mdfrepair.net/download-free.html

paula willey · Answer

The MDF files of SQL database may get corrupt due to some problem in the database. If such a situation arises the user can use the software which recovers the lost MDF file. But before choosing the software make sure that it is efficient enough to recover the unique keys primary keys indexes stored procedures views etc from your corrupt MDF file. You can try this :- http://www.filesrecoverytool.com/sql-database-repair.html

Ashok Sharma · Answer

?C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataMYDATABASE.mdf is 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 Mohapatra · Answer

Check the version of sql server by select @@version if the version different then it will through error am sure your data file got corrupted try to install full backup or install it on the right version good luck