How do I copy a database to a different server?

[JennB]

Hi,

I am new at this and have created a sql server database on my own server. I need to copy this database to another remote server. I understand the import/export wizzard but it seems to only give me the option of my own local servers to copy to. How do I include other servers through their web or ip address?

Thanks for your help.

 

[tlbroadbent]

Use the Client Network Utility to create an alias for remote servers. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[JennB]

Thanks for your help. I took your advice and tried to make an alias with the network utility. When I run the import/export wizzard with this alias as the server it tells me "sql server does not exist or access is denied." I don't think I set up the alias properly. I know this seems stupid but which network library do I use and where do I put the web address?

Thanks again.

 

[tlbroadbent]

You will probably want to use TCP/IP if the remote server and local server are setup to use the net library. Put the IP address of the remote server in the Server Name box. Use an easily remembered name in the alias. You may need to enter a port number if the remote server listens on a port other than 1433.

You may be able to use named pipes or multi-protocol if the remote server is configured for one of those libraries and is on an accessible domain.

If the remote server is behind a firewall, you may not be able to get to it unless the remote network admin opens the SQL Server listen on port for access through the firewall. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[wsmall73]

Correct me if I am wrong but you could also do a backup and restore. Where you restore your database on the desired server?