Transactional Replication using SQL Server 2008
Posted on 2016-09-28
I got a very critical SQL database which is the main database for our Public Safety 911 software it is approximately 160 GIG DB. I am trying to create a transactional replication of this data over to another SQL Server. I am only trying to replication about 20 of the 800 + tables in the database. Every time I create the publisher and subscriber and do the initialization, the 911 software slows down or crashes and I have to stop the initialization. I am fairly new to replication but I don't understand why it would slow the vendor software down. Am I overlooking something or is this the only way to get the data over to the subscriber? Any help would greatly be appreciated.