freelancersblog.net

 

Setup SQL Server Replication between 2 remote hosts

February 7th, 2011

We have two remote servers. 1. Is a live server 2. Is a Reporting server. I require log shipping to setup for twice a day from the live server to the reporting server. The logs will need to be FTP to the reporting server and imported automatically. We had something setup previously but it keeps going out of sync, which may be possible to use and amend as needed. I require email notifications of any failures in import to action if it gets out of sync. I also require previous backups to be …

Original post by Freelancer.com - New Projects

 

Setup SQL Server Log Shipping between 2 remote hosts

February 7th, 2011

We have two remote servers. 1. Is a live server 2. Is a Reporting server. I require log shipping to setup for twice a day from the live server to the reporting server. The logs will need to be FTP to the reporting server and imported automatically. We had something setup previously but it keeps going out of sync, which may be possible to use and amend as needed. I require email notifications of any failures in import to action if it gets out of sync. I also require previous backups to be …

Original post by Freelancer.com - New Projects

Comments