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

Configuring publication properties

On the Publication Properties screen, we can see the publication Name, Database, Description, Type (of replication), and Subscription expiration. Based on the business demand, we should decide the retention period for subscription. If we select the Subscriptions expire and may be dropped if not synchronized in the following number of hours option, this will drop the subscription if it exceeds the interval, which is really dangerous. Instead, choose the Subscription never expires but they can be deactivated until they are reinitialized option.

Configuring publication properties

Click Articles on the left-hand side of the dialog box and click on the ...

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