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
weeraa
0
Light Poster
Recommended Answers
Jump to PostWhat 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 …
Jump to PostFor SQL I usually back up to a local folder using SQL's tools.
I then run a scheduled task to syncronize the backups using ROBOCOPY to a remove host.For a monthly, I FTP a copy of a FULL SQL backup offsite to a VPS running out of state.
All 7 Replies
JorgeM
958
Problem Solver
Team Colleague
Featured Poster
weeraa
0
Light Poster
kedarc68
0
Newbie Poster
weeraa
0
Light Poster
djshotmail
0
Newbie Poster
CimmerianX
197
Junior Poster
SudoWin
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.