Configuring Transactional Replication

DBAforever · October 14, 2021, 12:01pm

Hi experts, it's been a while since I setup t-repl. When I config it (for all articles in the db), do I need to do a backup and restore of the db on the subscriber first? Doesn't the initial Snapshot do that anyway?

Thanks,

ahmeds08 · October 14, 2021, 12:09pm

It happens through the snapshot.

robert_volk · October 14, 2021, 1:40pm

In addition to snapshot, initialize from backup is an option:

DBAforever · October 14, 2021, 8:49pm

Thanks guys. We hit a compatibility issue - can't replicate a 2008 db to 2019.
So my next question is: Can the DataCenter 2019 O/S support/host a SQL 2014 instance?

Thanks

robert_volk · October 14, 2021, 8:57pm

According to the documentation (archived copy) it can:

https://web.archive.org/web/20190403215347/https://docs.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server?view=sql-server-2014

Bear in mind that SQL Server 2014 no longer has mainstream support from MS, you'd have to purchase extended support if you need it.