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 |
|
fmardani
Constraint Violating Yak Guru
433 Posts |
 Posted - 2005-07-21 : 11:14:43
|
| Hi,How do you restore a table in sql server 2000 from the backup?Thanks |
|
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
Posted - 2005-07-21 : 11:50:59
|
| 1) Create a new DB2) Restore backup to new DB3) DTS table from new DB to old DB4) Delete new DBorUse Litespeed to backup and restore. If I'm not mistaken it has the ability to restore specific tables rather than the entire DB.DanielSQL Server DBAwww.dallasteam.com |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-07-21 : 11:52:08
|
Restore the database backup to a new database, and copy the table out of the new database to your old database.quote:
Originally posted by fmardani
Hi,How do you restore a table in sql server 2000 from the backup?Thanks
CODO ERGO SUM |
|
|
|
|
|
|
restore table