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.
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…