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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-01-16 : 09:52:47
|
| Karunakaran writes "Hi, I deleted a table from in a database in sql server 7 from the enterprise manager...I dont have a back up of the DB also...Is there any way to restore that table????Pls help me out..As the table contains important datas...Regards,Karunakaran" |
|
|
Nazim
A custom title
1408 Posts |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-01-16 : 22:04:01
|
| What ? You mean SQL Server doesn't have a Recycle Bin ?????OoopsSorry Karunakaran, you are out of luck. I have 3 words for youBackupsBackupsBackupsUse this as a lesson and get a good backup plan in place.Damian |
 |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2002-01-16 : 22:56:36
|
You guys are harsh. And besides, you forgot the only method available. Data entry. Edited by - rrb on 01/16/2002 22:57:15 |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-01-16 : 23:13:00
|
It is a harsh lesson, hopefully one you only need to learn once.As for data entry, preferably get someone else to do it  Damian |
|
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2002-01-16 : 23:19:06
|
| That makes it an SEPI hope that when I die someone will say of me "That guy sure owed me a lot of money" |
|
|
|
|
|
|
Restoring a deleted table