If you compare different databases you find MS SQL as one of the best database management system among all. It is most preferable and widely used DBMS all over the world. It offers easy and safe database management with a facility of data query, update modification and access control. You can use it to store large volume of data like inventory details, client information and other. All these information are stored in the form of .mdf files in MS SQL server database which are prone to corruption. When these files are corrupted you are unable to access the database and encounter various error messages. In such terrible situations you need to recover corrupt SQL database in order to access your data.

While working with SQL database most of the people face a problem of mdf file corruption due to which hard disk containing database transaction log failed. When you try to replace the hard drive using command sp_attach_single_file_db for primary data file you receive following error messages which is difficult to resolve:

• Msg 945, Level 14, State 2, Line 1 Database‘database Name? cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details
• Server: Msg 945, Level 14, State 1, Line 1 Database your 'database name' cannot be opened because some of the files could not be activated.
• Server: Msg 1813, Level 16, State 1, Line 1 Could not open new database ’your database name'. CREATE DATABASE is aborted.

After the error appears your database becomes inaccessible and sometimes it also creates serious data loss situations. So, to recoup such dreadful situations you have to recover corrupt SQL database.

Usually such types of error messages appear due to corruption of mdf files which occurs due to various unavoidable reasons like as:

• Sudden termination of SQL server
• Hard drive failure
• Problems in cache
• Internal program error
• Wrong string to multi client database with user
• Oversized database file

Whatever is the cause of corruption but it results in serious problems which make you annoyed. To overcome such problems and recover corrupt SQL database follow the below mentioned steps:

• De-attach corrupt SQL database
• Replace failed hard drive
• Try to delete damaged database using Server Enterprise Manager Console
• ICreate a new database with same logical and physical file name and store entire files of suspect database in same directory
• Run DBCC CHECKDB command to restore corrupt database

However, if you experience same error again then use MS SQL Database Repair Software. The software safely repair corrupt mdf files and recover corrupt SQl database.