Recovering a deleted database in SQL Server 2005

Tags:
Recovery
SQL Server 2005
SQL Server database
I've accidentally deleted a database on SQL Server 2005, and I do not have a backup. Is there any way to recover it?

Answer Wiki

Thanks. We'll let you know when a new response is added.

First of all you check transaction log backup which contains the data and transaction log chain since the last full backup. If you have these then you can easily restore your database otherwise you will need to purchase a third party tool such as Lumigent’s Log Explorer to read the transaction log.

Pawan Mothsra

The OP said they had no backup, so they can’t check it. Check your drives for any .mdf, .ndf, .ldf files. If they are still there you can attach the database in Management Studio. If they’re not there, you’re out of luck. Hard way to learn about the importance of backups.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following