Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 Recovering dropped tables from an MSSQL database

Author  Topic 

debaryan
Starting Member

2 Posts

Posted - 2009-05-25 : 15:09:58
Hi,
Accidentally i deleted half the tables from our application database. I need to restore/recover them in 4/5 hours else, i am will be out of this world !!

Please help

thanks
deb
debdas.sinha@gmail.com

nr
SQLTeam MVY

12543 Posts

Posted - 2009-05-25 : 15:10:47
Restore a backup of the database and copy the tables.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

sagitariusmzi
Posting Yak Master

113 Posts

Posted - 2009-05-27 : 04:55:21
You can also use point in time Recovery
Go to Top of Page

Skorch
Constraint Violating Yak Guru

300 Posts

Posted - 2009-05-27 : 15:44:27
So what happened? Are you still in this world?

Some days you're the dog, and some days you're the fire hydrant.
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-06-14 : 11:45:05
I hope you still have your job.
Go to Top of Page

tosscrosby
Aged Yak Warrior

676 Posts

Posted - 2009-06-15 : 15:32:03
Lack of updates for 3 weeks would seem to indicate they are "out of this world"!

Terry

-- Procrastinate now!
Go to Top of Page
   

- Advertisement -