Tag Info

New answers tagged

1

Instead of having the trigger rely on the linked server being available, use a queue table. Have a background job that can use sp_testlinkedserver and process all of the items in the queue only when the server is available. It can use TRY/CATCH as well, and only mark those as processed when they are successfully updated, otherwise it will continue trying ...


2

To initialize a Transactional subscription from a backup you actually end up creating the publication first, enabling it to initialize subscriptions from a backup, then take a backup, and then initialize subscriptions with the backup. Changes that occur after taking the backup and before initializing the subscription(s) will be stored in the distribution ...


0

this isn't so much an answer as a workaround. I am saving the value generated in the trigger on a table on the subscriber with the primary key of the transaction from the publisher. Then the application is querying that table on the subscriber immediately after the insert.


1

The Snapshot Agent process account used to connect to the Distributor must be db_owner in the distribution database and have read, write, and modify permissions on the snapshot share. The account used to connect to the Publisher must be db_owner in the publication database. The Log Reader Agent process account used to connect to the Distributor must be ...


-1

It's not a good practice to use the SQL Server name when configuring the connection. To connect to a SQL server, you need to specify 2 parameters: Server IP address and port. If you only specify the SQL Server name, then you will depend on the naming resolution, it may or may not work as you expect. So the best practice is to use SQL Alias, for more info on ...


0

I found a simple solution here. Distribution Agent - Start /Stop in T-SQL -- To STOP the Distribution Agent: sp_MSstopdistribution_agent @publisher, @publisher_db, @publication, @subscriber, @subscriber_db --To START the Distribution Agent: sp_MSstartdistribution_agent @publisher, @publisher_db, @publication, @subscriber, @subscriber_db My complete ...


0

There seems that some people used to patch the source code of xtrabackup to make it usable in OSX: http://sourceforge.net/projects/xtrabackup-osx/ But expect some problems, as some of the functionalities depend on a linux system (but you can try to give it a shot). The other alternative is MySQL Enterprise backup, which has full Mac compatibility. 1) You ...


0

This is possible. I have seen it in production, enterprise level. Cons: The subscriber has to be initialized and completely caught up with undistributed transactions before it can be set it up as a publisher. Initializing the second subscribers must be done via backup/restore. The re-distributor can block the first distributor if you create a snapshot and ...


1

If your server's ip address is static, you can modify your hosts file with a reference to DBNODE2's ip address and specify DBNODE2 in your Connect to Server Server Name file.



Top 50 recent answers are included