Home > IT Answers > Storage > SQL Server backup to remote internet location
Amitguptaais
5 pts.
 SQL Server backup to remote internet location
SQL Backup, SQL Database, SQL Server, SQL Server backup
We have one server with 2 SQL databases with size 1.5GB and 6GB,
Daily new transactions are added to the system. Now we want a solution that this SQL gets backed up / replicated at some remote internet location on daily basis. Since we cannot transpot full 1.5GB file or 6GB file on daily basis, how to make the system in such a way that It transfer only the current day transcations on daily basis, and replicate data there.


Software/Hardware used:
ASKED: October 12, 2011  10:21 AM
UPDATED: October 20, 2011  2:57 AM
RELATED QUESTIONS
Answer Wiki:
Backups can be done via the normal backup processes in SQL Server via the BACKUP DATABASE and BACKUP LOG statements. Getting the data to an internet location. How you get the files to that location will depend totally on the internet location that you will be uploading the files to.
Last Wiki Answer Submitted:  October 20, 2011  2:55 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _