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

Configuration

Here is the T-SQL code to set up a primary and Secondary Server for Log Shipping. The scripts are generated by choosing the appropriate Script Configuration... option in the GUI window that appears after right-clicking on the database, and then selecting Tasks | Ship Transaction Log.

Configuration

Setting up Primary Server for Log Shipping

So far we have learned how to install Log Shipping using GUI. Let's now see how to set up Primary Server for Log Shipping using the T-SQL script generated from SSMS.

Note: This chunk of code needs to be executed in a single execution/single step DECLARE @LS_BackupJobId AS uniqueidentifier DECLARE @LS_PrimaryId AS ...

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