Remote to Remote

Hi,

We have 3 database server . one is local and other two are in two different locations.

Scenario is , we have to import a database from one old remote server to another new remote server.
Since, it should be difficult (bcoz of firewall issues) to import from old remote to new remote server, i thought to
import to my local DB server then import database to new remote server.

I am planning to give IMPORT/EXPORT option in the ALL TASKS property, from my local m/c to the old remote server.
then take BACKUP database in my local machine . After that just copy the backup file to my new Remote server and then
just restore it.

Or is there any better solution to accomplish this ?

Please give me some advice !

Thanks,

HadleyWhy not consider using REPLICATION or LOG SHIPPING kind of solution rather depending on roundabout solution. Refer to books online for more information.

Remote connection stopped working

My new and my old applications used to work remotely without problems. Using VS 2003.
Both could connect using the server name or ip address.

Now neither one works now, meaning they can't connect.
Message is that the server doesn't exist.

I can only connect using the server name now, NOT the ip address.

I even tried connection with fire wall off.

Do you mean that you can access the server using the servername but not the IP Address?|||Please follow the instruction at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=362498&SiteID=1 and give us more details if it does not solve your problem.