Recovery DataBase

you want teh deleted database in sql server 2005 . you have to retrieve the database means in c: you have to search *.mdf you can get the database

MuthuKumaran.R
Senior Software Engineer
Techcello
India.

Santosh4u, if this helps please login to Mark As Answer. | Alert Moderator

If you have already deleted the database, as well as files, you need to use File Recovery softwares to get files by manual tracing over clusters in your hard drive.

There is no SQL Server way to do this.

www.abhisheksur.com

Santosh4u, if this helps please login to Mark As Answer. | Alert Moderator

Unfortunately unless you have some kind of backup you are probably not going to have much luck.

If you have a .bak then you can restore it.
If your server hosting company makes backups you can restore it.
If you have special software I think you can undo individual records by using the transaction log
If your server has shadow volume on it the maybe you can restore the .mdf

If none of the above then you can only hope to learn from your mistakes and always keep some kind of backup of your data before you do work on it in future!

There is also a very slim chance that you might be able to get the database back if you install some undelete software. The best course of action would be to take the hard drive out and install the undelete on a different system and then hook the hard drive in as a secondary slave hard drive. That way you dont run the risk of writing over your deleted file when you install the undelete app.

Santosh4u, if this helps please login to Mark As Answer. | Alert Moderator

hi Mcamkumaran

no,there is no mdf file of same database in c:

Santosh4u, if this helps please login to Mark As Answer. | Alert Moderator

If you have the problem regarding the corruption in the SQL Server 2005 then you should first use the command DBCC CHECKDB command to rectify the reason of the problem. Once the problem is found, you can choose the right solution. If there is a simple corruption then you can repair it using DBCC with correct parameters but if there is some big corruption then you should use professional SQL Server recovery application that can perform complete SQL Database Recovery. There are several applications available for this task so choose one and fix all the corruption in Microsoft SQL Server 2005. For more information http://www.sqldatabase-recovery.com

Regards,
William Pablow
http://www.mdfrepair.com

Santosh4u, if this helps please login to Mark As Answer. | Alert Moderator

Hi Santhosh

The following steps to recover the DELETED Data...! But not REMOVED Database.

You can recover the DELETED data back! If you have the following recovery plan...

1. Is your Database Recovery model is FULL / BULK_LOGGED ?
2. Do you have any Full backup taken before the actual DELETE...?
3. The LOG should not be TRUNCATED after the Last FULL backup taken (Shrink/Rebuild/Truncate)
4. You have to take LOG backup Immediately after the actual DELETE (Tail-Log Backup).

If all the activities are TRUE!

1. Restore the FULL backup (.bak) taken before with NORECOVERY or STANDBY mode.
2. Continuously, Restore the LOG backup talen now with "STOP AT" (at what time you have performed the DELETE ?) with RECOVERY mode.

Note: These steps are used to recover the DELETED data / Schema. But, There will be a minimum lost of data after the "STOP AT" timestamp you used.

Cheers

Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

Santosh4u, if this helps please login to Mark As Answer. | Alert Moderator

SQL files may be recovered due to http://mdfrecoverytool.com . The tool can work with mdf files up to 16TB. It can't modify your source files and program create the copies of data. The utility starts under all major versions of Windows OS.

Santosh4u, if this helps please login to Mark As Answer. | Alert Moderator

In order to restore deleted SQL 2005 database you need to use third-party SQL Database Recovery Software. With the help of this effective recovery software you can easily restore damaged and deleted .MDF files to the specified location. It safely restore lost SQL objects like tables, views, indexes and triggers etc. This comprehensive software supports all version of MS SQL and restore the database within few clicks. So, you can try this effective software.

For more information visit:http://www.sqldatabase-recovery.com

http://www.sqldatabase-recovery.com

Santosh4u, if this helps please login to Mark As Answer. | Alert Moderator

Hi

Albert_Eines

Is that Really Work and Restore all data?

Regards

R D Patel

Santosh4u, if this helps please login to Mark As Answer. | Alert Moderator