Log Shipping vs Replication
Posted on 2003-11-25
We have a production database on SQL 2000 Enterprise running a 3rd party application.
Users imput data using the application and reports are run against it using custom written reports in VB, Access, and Crystal Reports.
We would like to add a second server as a reporting server and an online backup in case of a server crash on the primary. I have never used Replication in a production environment (have configured it in a test environment) and have never used Log Shipping.
Which would be the best reporting, which would be the best for online backup and what are the pros and cons of each?
This is my first question so feel free to let me know if I should give more info.