all groups > sql server data warehouse > may 2004 >
You're in the

sql server data warehouse

group:

recovering deleted table


Re: recovering deleted table Adam Machanic
5/25/2004 10:00:18 AM
sql server data warehouse:
Unfortunately, there is not. You can, however, restore the database to a
different server (or, just a different database) and then copy just the
table you want back to the original server/database. That way, you won't
effect the active database with the restore.

[quoted text, click to view]

recovering deleted table Rea Peleg
5/25/2004 12:26:11 PM
Hi all
Is there a way to reconstruct a table which was deleted without restoring
the whole data base?
Database recovery model is simple. Sqlserver version is 2000 sp3.
TIA
Rea

AddThis Social Bookmark Button