I am trying to set up replication between databases. I followed this tutorials: https://docs.microsoft.com/en-us/sql/relational-databases/replication/tutorial-preparing-the-server-for-replication?view=sql-server-ver15 and after: https://docs.microsoft.com/en-us/sql/relational-databases/replication/tutorial-replicating-data-between-continuously-connected-servers?view=sql-server-ver15 I went through first without any problems. Almost completed the second, but I stuck on step View the status of snapshot generation When I try to strat snapshot agent, I get error: Exception Message: An unspecified error had occurred in the native SQL
Tag: replication
Why use GTIDs in MySQL replication?
When it comes to database replication, what is the use of global transaction identifiers? Why do we need it to prevent concurrency across the servers? How is that prevention achieved exactly? I tried to read the documentation at http://dev.mysql.com/doc/refman/5.7/en/replication-gtids.html but still could not understand it clearly. This may sound very basic but I would really appreciate it if someone could
Does SQLite support replication?
In an application which embeds SQLite3 and uses an in-memory database, is it possible to replicate the database between two running instances of the application? I could do this by hand with a homebrew protocol duplicating all my DB accesses, but it seems like something that should be done inside the DB layer. Answer Brute force approach: Send it the