I need someone to help me setup SQL Server 2005 replication on my server. I have the following requirements.
1. I have a live server which users access and make changes to.
2. I have a report server which serves our web reporting users.
3. Both servers are on different networks, (both windows however)
4. File transfers are to be done by FTP between both servers.
So i have a report server that needs to be replicated from the live server.
I'm happy to either go for log replications (so a form of log shipping) or to do daily full backups and restore the database every night on the report server.
However the full backups are about 2GB so it might be better to do log backups and restores. I need this done pretty urgently and it needs to be someone who knows what they are doing.
You will be provided remote access to both servers using VNC and remote desktop.
Please only respond if you are capable of doing such a job.