There are 2 servers. (I named those 2 servers in this post as "server1" and "server2". Those 2 servers are link together via VPN) i want to backup server1 data to server2. This should be done automatically in every day in some fix time. I know how to back up server1 data to some location of server1. But Still i couldn't find a way to do this with 2 servers. PLEASE TELL ME HOW TO DO THIS.
Server version: SQL server 2008
Jump to Post
What backup software are you currently using? Does this backup software allow you to backup to a UNC path? Some backup software only allows local hard drive access.
If your backup software only allows access to the local drive, you could run a scheduled task to copy the local backup …
All 7 Replies
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.