SQLTeam.com | Weblogs | Forums

Configuring Transactional Replication

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,

It happens through the snapshot.

1 Like

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

1 Like

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

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.