Having trouble signing in? Try this!
Ask questions. Help others.
The HP Community is here for you.
Post new question
Question
Reply
 
Note on archived topics.
This topic has been archived. Information and links in this thread may no longer be available or relevant.
If you have a question create a new topic by clicking here, or click on "Post new question" above and select the appropriate board.
Top Student
Posts: 5
Member Since: ‎05-08-2014
Message 1 of 7 (836 Views)

Basic tips to recover MDF file from corrupted SQL server

Hi users,

share the basic tips of MDF file recovery with good example and when the tool support with all over MS windows and MS SQL server.

0 Kudos
Tutor
Posts: 10
Member Since: ‎04-04-2014
Message 2 of 7 (812 Views)

Re: Basic tips to recover MDF file from corrupted SQL server

It is better to provide the detailed symptom of your corrupt SQL Server database since the recovery process may be different from case to case. For example, you should list the error message generated by SQL Server.

 

You may refer to this post regarding similar discussions regarding SQL Server database recovery:

 

http://h30434.www3.hp.com/t5/Desktop-Operating-Systems-Software-Recovery/Major-error-in-SQL-server-H...

Honor Student
Posts: 4
Member Since: ‎05-08-2014
Message 3 of 7 (797 Views)

Re: Basic tips to recover MDF file from corrupted SQL server

You can easily run DBCC CHECKDB command to simply recover mdf file from corrupted sql server database. But sql server doesn’t give any assurance to provide healthy or original data when you use this command.

 

Sometimes this command gets unable to recover .mdf file, then you can try third party tool. I have already used a third party tool to recover my suspect database and that is sql Recovery software. From here I downloaded it: http://www.sqlrepairtool.net

Honor Student
Posts: 2
Member Since: ‎07-09-2014
Message 4 of 7 (659 Views)

Re: Basic tips to recover MDF file from corrupted SQL server

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.

 

Download:- http://www.pcrecoverytools.com/sql-database-recovery.html

Student
Posts: 1
Member Since: ‎08-13-2014
Message 5 of 7 (608 Views)

Re: Basic tips to recover MDF file from corrupted SQL server

[ Edited ]

MS SQL database recovery tool is a powerful tool that provides restoration of SQL database after any losses. Get more detail: http://www.recovery.repairsqlserver.net and more details read this post. http://recoverymaster.livejournal.com

Honor Student
Posts: 3
Member Since: ‎09-19-2014
Message 6 of 7 (569 Views)

Re: Basic tips to recover MDF file from corrupted SQL server

Go through http://www.filerecoveryutility.com/sql-recovery.html to follow the steps and repair your database manually.

Honor Student
Posts: 3
Member Since: ‎11-01-2014
Message 7 of 7 (518 Views)

Re: Basic tips to recover MDF file from corrupted SQL server

Basic solution to recover MDF file from corruption is to run DBCC statements. It is a set of SQL statements -

 

1. Dbcc checkdb ('database_name') with no_infomsgs
You do not need to repair file if the above statement is executed without any errors. Before executing the repair operation, you need to set the database in single user mode by executing:

 

2. Alter database 'database_name' set SINGLE_USER
You can now start repairing process by using Repair_Rebuild model by executing:

 

3. Dbcc checkdb('database_name', REPAIR_REBUILD)
If this statement executes successfully, then execute 5.5 else execute:

 

4. Dbcc checkdb('database_name', REPAIR_ALLOW_DATA_LOSS)
This statement may lead to data loss. If it is executed properly then execute 5.5 else execute:


5. 5.1 Alter database 'database_name' set EMERGENCY
5.2 Alter database 'database_name' set SINGLE_USER
5.3 Dbcc checkdb ('database_name', REPAIR_ALLOW_DATA_LOSS) with no_infomsgs, all_errormsgs
5.4 Alter database 'database_name' set ONLINE
5.5 Alter database 'database_name' set MULTI_USER

 

Click here to get complete guide to repair MDF file.

† The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation