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.
| Author |
Topic |
|
Ravi101
Starting Member
2 Posts |
 Posted - 2009-07-22 : 13:27:37
|
| HII DROPPED DEPT TABLE WHICH IS A MASTER'S TABLE FOR MY SCOTT USER AS I ACCIDENTLY DROPPED THE TABLE M UNABLE TO SEE SOME OF MY RECORDS ON EMP TABLE ..CAN U PLZ HELP ME OUT .. TNX IN ADVRAVIRAVI |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-07-22 : 13:32:27
|
What kind of backup strategy you're using?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2009-07-22 : 13:33:35
|
welcome to the club.Getting your fingers burnt is the best way to learn. he hee  |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-07-22 : 13:34:14
|
I hope he isn't dead jim...
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
Ravi101
Starting Member
2 Posts |
Posted - 2009-07-22 : 13:38:11
|
| full backupRAVI |
|
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2009-07-22 : 13:54:30
|
| Full restore to a new database and then export the dropped table from the new database into the existing database. Delete the new database when complete. Check out BOL for details.Terry-- Procrastinate now! |
|
|
|
|
|
|
Plz help me !!