Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Restore from remote location Expand / Collapse
Author
Message
Posted Friday, August 5, 2011 5:03 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 4:19 AM
Points: 2, Visits: 97
Hi everybody,

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!!
Post #1154911
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse