Replication and log shipping are two features of SQL Server that are used for managing data and ensuring that it is available in multiple locations. Both of these features can be useful for organizations that need to maintain multiple copies of their data in different locations, such as for disaster recovery or to support multiple locations. Replication….. is a process …
I can remember several years ago every time someone mentioned SQL Server replication you would hear a dull groan. It is one of those things that certainly has some barriers to entry to learn how it works and what you need to do to keep it running. Not me, I get excited about working with replication. I work with several …
The more and more I work with replication the more and more I run into weird errors like this one. SQL Server replication requires the actual server name to make a connection to the server. Specify the actual server name. (Replication.Utilities). You might be thinking to yourself that you had a typo in the server name, but no, after checking …
SQL Server replication requires the actual server name to … Read more »
I have been doing more and more replication work lately, and when recently testing some replication work I needed to create and drop some test databases and re-test the replication work. After configuring a database for replication, then deleting the publisher and the subscriber I attempted to drop the database and get the following error: Msg 3724, Level 16, State …
Cannot drop the database because it is being used for replication. Read more »