Initialize SQL Server replication usi…
https://www.mssqltips.com/sqlservertip/2386/initialize-sql-server-replication-using-a-database-backup/
Initialize SQL Server replication using a database backup Configure the publication and choose the database you want to participate in replication. Choose the type of replication and select the tables you want to participate in replication. Decide if you want to use a snapshot or not. Create a backup of the publication database using the BACKUP (Transact-SQL) statement. Restore the backup on the Subscriber using the RESTORE (Transact-SQL) statement. Create a subscription using T-SQL. Validate that the snapshot was not created. Snapshot Agent Settings To do this, when setting up replication we need to make sure that we do not create the snapshot immediately while configuring the new publication. ... Step 1: First, Configure the publication and choose the database, which you want to participate in replication.
Configure the publication and choose the database you want to participate in replication.
Choose the type of replication and select the tables you want to participate in replication.
Decide if you want to use a snapshot or not.
Create a backup of the publication database using the BACKUP (Transact-SQL) statement.
Restore the backup on the Subscriber using the RESTORE (Transact-SQL) statement.
Create a subscription using T-SQL.
Validate that the snapshot was not created.
Snapshot Agent Settings To do this, when setting up replication we need to make sure that we do not create the snapshot immediately while configuring the new publication. ...
Step 1: First, Configure the publication and choose the database, which you want to participate in replication.
DA: 99 PA: 17 MOZ Rank: 50