dcsimg
Results 1 to 4 of 4

Thread: how to take DataBase Backup from remote server to local system

  1. #1
    Join Date
    Oct 2010
    Posts
    24

    how to take DataBase Backup from remote server to local system

    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...

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Backup db on remote server, copy backup file to local disk then restore.

  3. #3
    Join Date
    Jul 2012
    Posts
    2
    As mentioned above, in case if you have access on remote server via UNC path you can use such tools as SQLBackupAndFtp or IBackup or similar.

  4. #4
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,912
    As long as your sql agent service account has access to remote destination (using UNC), you can schedule native backup to write to remote server.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •