My MDF File is Corrupted

[jetchan]

Hi All,
I am in a problem with my SQL Server actually I am using a sql server 2005 and all the data store in my sql database in the form of .mdf file but few days ago my .mdf file is not open properly and it's seems blank while I store so much data in my database and when I talk to admin according to my problem he says that the mdf file is corrupted can you please help me to how recover my data I am so much appreciate of your kind help.

[gk53]

I hope you have database backup. If so you can restore database from backup, you will lost data from last backup to database crash, but it wold be the best option. Another question Is your transaction log files still good? If they are not corrupted you can after restoring database from backup you can restore from transaction log up to crash time and your data lost will be minimal... God luck

[jetchan]

I hope you have database backup. If so you can restore database from backup, you will lost data from last backup to database crash, but it wold be the best option. Another question Is your transaction log files still good? If they are not corrupted you can after restoring database from backup you can restore from transaction log up to crash time and your data lost will be minimal... God luck

Dear Gk,

Thank you very much for your valuable response i want to told you that i have backup of database but not sure it's corrupted or not because there are some error occur when going to open database but my log file is in working condition.

Now please tell me how can i recover it.

Thanks

[gk53]

Restore database from backup into new database.
Is that works? Below link with instructions of how to do that
http://www.tech-recipes.com/rx/2081/sql_server_2005_how_to_restore_database_backup/

[jetchan]

Hi Gk,

Once again thank you for your reply the link provided by you is very useful and i try my best to restore my database backup but i am fail to do this.

I can't restore database from my backup.
Have you any other way to restore database.
I read something about data recovery software in internet but not understand well if you have any idea about this please give me.

Thanks

[gk53]

if your corrupted database still online you can try to recover by

ALTER DATABASE yourDatabaseName
SET emergency
GO
ALTER DATABASE yourDatabseName
SET single_user
GO
DBCC checkdb (yourDatabaseName, repair_allow_data_loss)
ALTER DATABASE yourDatabaseName
SET multi_user
GO

If that will not help probubly you lost your database
You should have database backup plan (usially it is multiple jobs), wich should include full backups and backup of transaction log and keet a few backups avaliable for data recovery. On my servers I usially run full back up every night and stor 7 last full back ups for recovery on the same drive and off the system and on top of that I running backup of transaction log every 15 min, so in case of emergensy like you have you should be able to find good full db backup, restore database, and after that restore database from transaction log as close as you can before crash time, in my scenario it is 15 min... This is what you should consider for future

[jetchan]

if your corrupted database still online you can try to recover by

ALTER DATABASE yourDatabaseName
SET emergency
GO
ALTER DATABASE yourDatabseName
SET single_user
GO
DBCC checkdb (yourDatabaseName, repair_allow_data_loss)
ALTER DATABASE yourDatabaseName
SET multi_user
GO

If that will not help probubly you lost your database
You should have database backup plan (usially it is multiple jobs), wich should include full backups and backup of transaction log and keet a few backups avaliable for data recovery. On my servers I usially run full back up every night and stor 7 last full back ups for recovery on the same drive and off the system and on top of that I running backup of transaction log every 15 min, so in case of emergensy like you have you should be able to find good full db backup, restore database, and after that restore database from transaction log as close as you can before crash time, in my scenario it is 15 min... This is what you should consider for future

Hello GK,

Thank you so much i just going to do what you describe all points on above lets see i get back my database data or not.

Thanks

[jetchan]

Hello Jetchan,

DBCC CHECKDB with repair_allow_data_loss command is the last free method to repair corrupt mdf file but you may end with some data loss. If your data is most precious for you and you can't effort any single data loss then you should use 3rd party mdf repair software. There are so many mdf repair software available online but Stellar Phoenix SQL recovery is the best for you.

Hi Mark,

Sorry but not understand which type of command you are talking about can you please explain and about third party i read your suggestion thank you for this.can you please give me some other idea.

[markwillium]

Hi Mark,

Sorry but not understand which type of command you are talking about can you please explain and about third party i read your suggestion thank you for this.can you please give me some other idea.

I am talking about a command that is also mentioned by GK

"ALTER DATABASE yourDatabaseName
SET emergency
GO
ALTER DATABASE yourDatabseName
SET single_user
GO
DBCC checkdb (yourDatabaseName, repair_allow_data_loss)
ALTER DATABASE yourDatabaseName
SET multi_user
GO"

It repairs corrupt mdf file with minimum data loss.

[jetchan]

I am talking about a command that is also mentioned by GK

"ALTER DATABASE yourDatabaseName
SET emergency
GO
ALTER DATABASE yourDatabseName
SET single_user
GO
DBCC checkdb (yourDatabaseName, repair_allow_data_loss)
ALTER DATABASE yourDatabaseName
SET multi_user
GO"

It repairs corrupt mdf file with minimum data loss.

Dear Make,
I have no more idea about commanding language and my support team do this for me and they already use these command as it discuss above by GK.now i am searching for any application which recover my data have you any information according this type of problem.

[markwillium]

Have you tried the application that I have mentioned above? If not then try it now. You can download it from Stellar Phoenix office website.

Repair Steps:
Download free demo version
Run on your computer
Shutdown SQL server
Copy your mdf file to another location
Start SQL server
Scan copied file with Stellar phoenix SQL recovery
See the preview of your data
If you can see your data then buy the software to save it.

[jetchan]

Have you tried the application that I have mentioned above? If not then try it now. You can download it from Stellar Phoenix office website.

Repair Steps:
Download free demo version
Run on your computer
Shutdown SQL server
Copy your mdf file to another location
Start SQL server
Scan copied file with Stellar phoenix SQL recovery
See the preview of your data
If you can see your data then buy the software to save it.

Hey Mark,

Thanks for suggestion i will sure check the application provided by you and if it's work may be possible i can tack it.by the way i already download this software which is demo version let's see what happen next .

[markwillium]

Hey Mark,

Thanks for suggestion i will sure check the application provided by you and if it's work may be possible i can tack it.by the way i already download this software which is demo version let's see what happen next .

I hope that you will have your data. If you have found any problem during repair process then share with us. Good Luck

[backslas1]

I am agree with GK. The answers provided by GK is relay good. If u don't found out your solution .Then you should try any 3rd party software.

[jetchan]

I am agree with GK. The answers provided by GK is relay good. If u don't found out your solution .Then you should try any 3rd party software.

Hi Backslas,

I also agree with GK Information it's gathering so much useful information but dear i don't find out my solution and which type of 3rd party software you are talking about ,can you please explain if you have any Application which provide my problem's solution with support service.