Tag Archives: initialization

Automating Tranzactional Initialization from a backup in SQL Server

Scenario

There are situations where you might have a large SQL Server database that you need to replicate. Since the database is very large we want to initialize the Subscriber from the SQL Server backup and not use a snapshot.  How do we bundle all the steps together to achieve this without performing them manually?

Solution

I want to cover the basic steps needed to setup a “Push Type Transactional Replication”.  This tip assumes you already have an understanding of SQL Server Transactional Replication and I will show how to bundle all the steps into one process.  Continue reading Automating Tranzactional Initialization from a backup in SQL Server