November 12, 2002 at 12:33 pm
Is there a way to restore just one table from a backup ?
Adding the backuped (sic) table as a new table would be fine too.
TIA for the help.
João ALberto
November 12, 2002 at 12:44 pm
No, what you need to do is restore the backup to another database, and then DTS the table back to your original database.
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
November 12, 2002 at 12:51 pm
TKS Greg,
already done and worked fine.
November 15, 2002 at 9:12 am
I think it's interesting that in SQL Server 6.5 you have the ability restore specific tables only, if you wish. I'm not going to say anything positive about SQL 6.5, as I'm sure eliminating this capability made backups MUCH more efficient.
-Ken
November 18, 2002 at 8:14 am
The one other thing that you can do with very large tables is to place them on a separate filegroup and backup the filegroup as a separate backup file. So if you needed to restore the table you could do the restore of just that filegroup. It would need some upfront database design, to set up all the different filegroups. In this way you could even put fairly small code type tables all on a separate filegroup and back that up.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply