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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Restore a table from the backup

Author  Topic 

Blin
Starting Member

36 Posts

Posted - 2004-09-01 : 14:59:08
How do I restore a table from last night's differential database backup? I just want to restore a table from the backup. Thanks.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-09-01 : 15:36:53
You need to restore the database using the last full backup then the differential backup. Restore it to a different name so that you don't overwrite the original. So now you have two databases. Then move your table from the new one into the original.

Tara
Go to Top of Page
   

- Advertisement -