O'Reilly logo

Professional Microsoft® SQL Server® 2008 Administration by Steven Wort, Ross LoForte, Wayne Snyder, Ketan Patel, Brian Knight

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required