SQL Server DBA Tutorial 101-How to Create Snapshot Replication in SQL Server

In this video you will learn how to create snapshot replication in SQL Server using SQL Server management studio as well as using T-SQL script. You will also learn how to configure the publication for snapshot, best practices of configuring publications for snapshot replication, how to add database and it's articles in snapshot replication, configuring Publication agent security and best practices of security configuration of Publisher as well as Subscriber.
It also briefly talk about what exactly is publisher, distributor and subscriber in replication in SQL Server, also what is replication in sql server and replication components in SQL Server.

Blog post link for this video:

Visit our website to check out SQL Server DBA Tutorial Step by Step

[hellofriend]

Really detailed explanation. No time wasting video. Thank you for uploading.

[skyhigh]

May GOD bless you all the time. You guys are doing great job.

[krismaly]

This is a very nice video and I enjoyed watching and recommend others to watch. Narrator knows the topic and explains step by step with reasons.

Thanks

[ahmedtambe]

10:33, I would want to use the option "Run under SQL Agent Service account" as our publisher is on local physical machine and the subscriber is in Azure cloud hence the domain is different. How can i achieve this?

[Kingbezy]

Awsome Video. Sir. please i have a question. can replicate be configured in a stand alone environment?

[mehrozyoutube]

When i open new publication its return your system is not enabling for publication

[mhsnmhsn]

can set my website or ip in process account ?
and can make replication between database local and database in internet like website ?

[jahma]

I got the error while creating publiction: This database is not enabled for publication.
Unable to execute procedure. The database is not published. Execute the procedure in a database that is published for replication.

[nexusroc]

Hi Bro,
In replication case. Instance B pull some tables from instance A(for other users). I want to encrypt a column of one table in instance B (But don't want to encrypt the original table at instance A). How can I make this work?
Thanks a lot!

[handsomekhan]

Sir ! Please Must Reply Me, Is this Distributed Database ! What Type of Distributed Database its is ? For Example Centralized Database !

[jalalaali]

I don't know why you jumping the steps of the creation snapshot replication in SQL. so basically you have to create a service account and everything related with snapshot replication don't say you have an account created already. so you have to keep in your mind that as your followers we don't know anything about what you doing.so please step by step you don't have to miss any step, please