Retrive a dropped db from sqlserver2005

Question

Post reply

Retrive a dropped db from sqlserver2005

rames.net

SSC-Addicted

Points: 468
More actions
August 19, 2009 at 7:50 am

#138310

Hi,
I had mistakenly dropped a DB,
pls let me know how can I restrore the same database.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Restore from backup.

You do have a backup, don't you?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

rames.net SSC-Addicted Points: 468 More actions · Answer 2

I dont have any back up, it is not a critical db. But i want to restore it

is there any method is there to restore the db.

Pls help me in this regard.

regards,

Ramesh

Michael Valentine Jones SSC Guru Points: 64818 More actions · Answer 3

You need to have a backup for any database you might want to restore, "critical db" or not.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

If there's no backup, you're probably not getting it back. All database should have backups, critical or not. The only time I can see a DB not needing a backup is when it can be completely and trivially recreated from scratch.

Use your favourite search engine to search for undelete tools. There's a very slim chance that a tool may be able to undelete the database, though I haven't heard of anyone doing this successfully.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Silverfox SSC-Insane Points: 23150 More actions · Answer 5

if the database was not backed up via sql server. Is the server/machine backed up. Speak to your windows administration team.

--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

tosscrosby SSCoach Points: 18045 More actions · Answer 6

Silverfox (8/19/2009)
if the database was not backed up via sql server. Is the server/machine backed up. Speak to your windows administration team.

Depending on the backup methodology, this probably won't work,. If the database is online, the underlying files are "in-use" and conventional backups will not backup files that are in-use.

-- You can't be late until you show up.