I have a problem. we are having two servers one in China and one in US. Both are having Sql Server 2008 R2.
We would like to configure replication in next week. Prior to that, the database at US must be updated with the data present in china database server. The backup of the china server database is taken and put it into ftp site.
Now I want to perform restoration of that updated database into US server database. I have to connect to US server remotely. But I don't have the access permisiion. Without accessing it, I have to perform restoration of that database through SQL SERVER.
Can anyone pls suggest me how to download the backup file from ftp site and perform the restoration.
Thanks In Advance to all!!