December 28, 2009 at 7:30 pm
Hello. I wanted to know if it were possible to restore a single table in sql 2k. Someone mentioned that I can use DTS....what is DTS? We have good backups that reside on another system (they get backed up to that system). I don't mind using DTS but have no idea what it is or how to use it.
Thanks for the help!
🙂
December 28, 2009 at 8:09 pm
There is no native utility for restoring a single table. If you were using a third-party backup utility, that utility might have that capability.
The only way to do this from a native backup is to restore the backup to a *new* database with a different name. Then, you can export the data in the table - or compare the table in the *new* database with the table in the *current* database.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 30, 2009 at 12:51 pm
DTS is a SQL2000 tool, it's called SSIS in 2005 if I'm correct. It imports the data into SQL. For example: migrates content of an excel file into a SQL table. Might sound silly, but it's used all over the place from what I've seen. I have never got my hands on SSIS (2005 version of DTS) because I heard too many bad things about it.
December 31, 2009 at 1:34 pm
You can also use DTS or SSIS to "export" the contents of a table from one database to another onto the same server or on different servers if they are linked. They are decent ETL tools. You will need to restore the database to a "new" database as already sugggested.
-- You can't be late until you show up.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply