I am setting up a seperate sql server on a different network to act as a backup server in case the production sql server goes down. I would like to know what is the best way to do this. I was thinking about using ssis on the backup server and pull the data each night from the production sql server. Is this the best way to go? I also want to load the data the first time and then just update with changes. Is this possible using ssis?