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

how to take DataBase Backup from remote server to local system Expand / Collapse
Author
Message
Posted Wednesday, December 15, 2010 10:10 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, June 19, 2013 11:21 PM
Points: 230, Visits: 157
hi..
i want to take the DB Backup from the
remote server to the local system..
i'm using sql server2008 enterprise edition and the remote server is sql server2008 express
how to do it..

please help me...
Post #1035645
Posted Thursday, December 16, 2010 3:21 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, August 13, 2014 6:42 PM
Points: 205, Visits: 1,015
on local machine create shared folder with full permissions..
on remote server take backup
example

backup database model to disk ='\\localmachinename\shared_foldername\model.bak'
Post #1035719
Posted Thursday, February 13, 2014 9:32 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 3, 2014 2:11 AM
Points: 5, Visits: 11
Other Option: use this tool, it will store a fresh BAK file from a remote database to your local harddisk: https://www.fida.org/gc.aspx?p=1001&p1=7
Post #1541296
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse