SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 Recovering dropped tables from an MSSQL database
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

debaryan
Starting Member

India
2 Posts

Posted - 05/25/2009 :  15:09:58  Show Profile  Reply with Quote
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

United Kingdom
12543 Posts

Posted - 05/25/2009 :  15:10:47  Show Profile  Visit nr's Homepage  Reply with Quote
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

Pakistan
113 Posts

Posted - 05/27/2009 :  04:55:21  Show Profile  Visit sagitariusmzi's Homepage  Reply with Quote
You can also use point in time Recovery
Go to Top of Page

Skorch
Constraint Violating Yak Guru

USA
300 Posts

Posted - 05/27/2009 :  15:44:27  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 06/14/2009 :  11:45:05  Show Profile  Reply with Quote
I hope you still have your job.
Go to Top of Page

tosscrosby
Aged Yak Warrior

USA
676 Posts

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

Terry

-- Procrastinate now!
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000