Recovering a deleted database in SQL Server 2005
Home > IT Answers > SQL Server > Recovering a deleted database in SQL Server 2...
SQL Server Ask the Experts
2445 pts.
0
Q:
Recovering a deleted database in SQL Server 2005
SQL Server 2005, Recovery, 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?
ASKED: Aug 18 2008  6:38 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
RetroCat
75 pts.
0
A:
 RATE THIS ANSWER
+1
Click to Vote:
  •   1
  •  0
  • AddThis Social Bookmark Button
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 (http://www.developerchoice.com)


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.
Last Answered: Aug 20 2008  7:11 AM GMT by RetroCat   75 pts.
Latest Contributors: PawanMothsra   165 pts., Mrdenny   46795 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Mrdenny   46795 pts.  |   Aug 19 2008  3:00PM GMT

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

 
0