enable-initialization-with-backup-for-transactional-publications.md

title	Enable initialization with backup (Transactional)
description	Learn how to enable initialization from a backup for a Transactional Publication in SQL Server.
ms.custom	seo-lt-2019
ms.date	03/07/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	replication
ms.topic	conceptual
helpviewer_keywords	manual subscription initialization [SQL Server replication] subscriptions [SQL Server replication], initializing initializing subscriptions [SQL Server replication], without snapshots transactional replication, backup and restore backups [SQL Server replication], transactional replication
ms.assetid	9df00514-aa9d-4ac6-9766-d226c9958175
author	MashaMSFT
ms.author	mathoma

Enable Initialization with Backup for Transactional Publications

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md] To initialize a subscription to a transactional publication from a backup, enable the publication to allow initialization from a backup, and then specify backup information when creating the subscription:

• Enable the publication on the Subscription Options page of the Publication Properties - <Publication> dialog box. For more information about accessing this dialog box, see View and Modify Publication Properties.

• Specify backup information with the stored procedure sp_addsubscription (Transact-SQL). For more information about the parameters required by sp_addsubscription, see Initialize a Transactional Subscription from a Backup (Replication Transact-SQL Programming).

To enable initialization with a backup

1. On the Subscription Options page of the Publication Properties - <Publication> dialog box, select a value of True for the Allow initialization from backup files option.

See Also

Initialize a Transactional Subscription Without a Snapshot