SQL Server Performance Forum – Threads Archive
Telnet
HiI have one server in US. Other server in India. Both servers are connectd through telnet services. I can able to open/access the entire database(US server) using my SQL 2000 query analyser or import/export through my local machine in India. Now my question how do I transfer the database to my local machine using import/export procedure? If I open import/export on my US server, I can save that to my US end server only.I want to transfer to my local server. I would like to know the procedure.
Thanks in advance
Krishna
Use REMOTE SERVER and LINKED SERVER from books online.
You can create BACKUP of remote database to a file and transfer the same using FTP and restore. _________
Satya SKJ
]]>