I want to backup selected tables from a database and restore it . How
can i do it

--

Thanks for the reply.

How can i use DTS to transefer selected database tables to same database
in another server?

--

darshini

Easiest way is to use the export wizard. Either start it from the
wizard tab in EM or right click database and start it from all tasks
option.

First screen is source server and database, second screen is target
server and database. Next screen choose copy tables. Next screen
select the tables you want. Last page decide when to run it. You can
run it immediately or schedule it later. It's usually a good idea to
also save it as a package in case you need to run it again.

Hope that helps