|
Home > Archive > MS SQL Server New Users > November 2005 > Resotre dropped tables
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Resotre dropped tables
|
|
| Loui Mercieca 2005-11-19, 9:23 am |
| Is there a way to restore a dropped table???
| |
| Tom Moreau 2005-11-19, 9:23 am |
| Restore a recent backup to a new DB. Create an empty table in the old DB
and then copy over the data to the table.
--
Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
"Loui Mercieca" <loui@destiny-creations.com> wrote in message
news:uMWeEzQ7FHA.2676@TK2MSFTNGP15.phx.gbl...
> Is there a way to restore a dropped table???
>
| |
| Mike Epprecht \(SQL MVP\) 2005-11-19, 9:23 am |
| Hi
Restore the Db and the transactions log up to the point you dropped the
tables.
Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Loui Mercieca" <loui@destiny-creations.com> wrote in message
news:uMWeEzQ7FHA.2676@TK2MSFTNGP15.phx.gbl...
> Is there a way to restore a dropped table???
>
|
|
|
|
|