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 - 2005-09-20 : 06:52:37
|
| Leon writes "How can I retrieve a Sql Server 2000 dropped table. I mistakenly dropped a table and I need to retrieve it.Is that possible?" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-09-20 : 06:55:01
|
| If you have a backup, then you can restore it (Note that you should have created that table before backup). or Just Recreate itMadhivananFailing to plan is Planning to fail |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-09-20 : 07:29:38
|
| Or restore to a new temporary database, copy the table & data across to your main database, and then Drop the temporary database.If you are running a TLog backup (i.e. Recovery Model is NOT set to Simple) you could make a transaction backup and then restore your previous full backup, all intervening transaction backups, AND the additional Transaction backup you just made, but ONLY up to the point-in-time just before the table was dropped.Kristen |
|
|
|
|
|
|
SQL Retrieving a dropped table