19.4. System Requirements
The servers that participate in log shipping must meet the minimum SQL Server 2008 hardware requirements; see Microsoft SQL Server 2008 Books Online. Additionally, certain hardware infrastructure requirements are necessary to deploy log shipping.
19.4.1. Network
The log-shipping SQL Servers must be networked such that the primary server has access to the backup folder, and the secondary server has access to copy the transaction-log files from the backup folder and into its local folder. In addition, the monitor server must be able to connect to both the primary and secondary servers. To improve copying the transaction-log file in a very active log-shipping environment, place the participating servers on their own network segment and use an additional network card dedicated to log shipping. Log shipping will function with any feasible network speed, but on a slow network the transaction-log file transfer will take longer, and the secondary server will likely be further behind the primary server.
19.4.2. Identical Capacity Servers
The primary and secondary servers should have identical performance capacity so that in a failover, the secondary server can take over and provide the same level of performance and user experience. Additionally, some organizations have service-level agreements (SLA) to meet. The SLA may require that you provide the same performance during failover as you would normally, requiring your secondary server to have the same capacity ...
Get Professional Microsoft® SQL Server® 2008 Administration now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
