Automatic backup of SQL function can backup the data to other server of the local area network (LAN)?
The SQL version 2008 r2
For example, in A SQL server, automatic backup of the evening want to backup to another server, LAN in the maintenance plan didn't see have set up the IP

CodePudding user response:

Database mirroring technology;
Replication technology;
The cluster;
Log shipping technology
That could be

CodePudding user response:

Set up a JOB, the JOB in writing your own BACKUP statements, written statement in the BACKUP target path with another server IP address of the Shared folder format,

CodePudding user response:

See my blog, very detailed:
https://blog.csdn.net/yenange/article/details/51499834