![]() ![]() After the first on though, I have been getting random errors. The initial synchronization of the subscriptions on all boxes goes like clock work. Not much to the subscription, just replicate the entire DB to each server every day. Since I have SQL versions from 2000 to 2008, I cannot just do backups and restores of the DB, which is the preferred method.Īnyway, so I set up a publisher from a SQL 2008 R2 Enterprise server, with the agents location on the same, and push subscriptions to 3 different servers, two 2005 servers and one 2000 server. My goal is to find a solution that allows me to have the DB updated in one place and then duplicated on as many as 65 SQL Servers at various locations on my network. ![]() Because of the nature of the network and distance between servers, management deems it necessary to have a copy on each server. This is a reference DB that the majority of my SQL Servers need to have available on them. I just set up snapshot replication as a test between Dev servers to see if that will fulfill my needs to duplicate the same DB across many DB servers. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
May 2023
Categories |