Backup to remote server

Feb 27, 2010 at 4:39 AM

Been using ExpressMaint on a couple of SQL servers and it works great!  Was wondering if there is a way to use this program to backup data to a remote server?  Any reply is greatly appreciated.

Jul 7, 2010 at 12:58 PM

From a performance/integrity perspective you are better backing up locally and then copying the file to the remote server - few reasons

  1. Your backup job won't take as long to run as it's working locally - less contention on your SQL box.
  2. Lack of connectivity doesn't stop the backup running only the remote copy.

Paul

Jan 17, 2013 at 2:36 PM

I am using remote desktop. I set backup everyday. But backup are failed.

Here is my error:

Failed to connect to server localhost\sqlexpress.
This SQL Server version (10.0) is not supported.
Expressmaint finished unsuccessfully at 11/3/2009 5:13:34 PM with Return Code(-3)

 

Firewell.

 

TehnicSystem