O'Reilly logo

Microsoft SQL Server 2008 High Availability by Hemantgiri S. Goswami

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

How Log Shipping works

As of now, we have understood what Log Shipping is and how it works. Now let's have a look at why we should have Log Shipping as a High Availability option or as a Disaster Recovery option in our environment. There are a few points I can pen down as a justification.

  • Easier to set up: It's really an easy job to create Log Shipping. The only thing we need to identify is that we must have two or three servers. The witness server( first is primary/source server and second is secondary/target server) is optional to configure, and it is acceptable if this witness server is not identical to other machines.
  • Manageability: Managing Log Shipping is the simplest among the available HA options that we have with SQL Server. There are ...

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