Azure SQL Sync Group Db Isolation Level Error
An error is given stating the database Isolation Level state is different between two databases when replicating between an Azure SQL database and an on-premise SQL database using the SQL Agent software installed on the on-premise server.
How do I fix this?
Solution
View the isolation state using this sql:
select name, snapshot_isolation_state, is_read_committed_snapshot_on from sys.databases
You want these settings to be both ON like below and the same on both the Azure and on-premise database.
The sql below is used to change the settings:
ALTER DATABASE {name} SET READ_COMMITTED_SNAPSHOT ON WITH ROLLBACK IMMEDIATE
GO
ALTER DATABASE {name} SET ALLOW_SNAPSHOT_ISOLATION ON
GO
- Exclude one file extension when starting synchronization from WinSCP command-line
- Android Studio how to run gradle sync manually?
- UB or not UB, concurrently operating on static memory in Rust
- Why use a ReentrantLock if one can use synchronized(this)?
- synchronizing audio over a network
- Synchronizing on String objects in Java
- Java synchronized and static synchronized method accessing static field
- Is there any compile-time mechanism in Java to attempt to ensure that use of a particular class is always synchronized?
- Is it safe for more than one goroutine to print to stdout?
- C++ Code Supporting Multiple Compilers
- Parallel programming: Synchronizing processes
- Double checked locking with ConcurrentMap
- Syncing different audio streams for one video
- Synchronizing multiple instances of same Greasemonkey script
- Using asio::io_context::strand to serialize posted tasks
- Is one SynchronisationContext used over multiple threads/tasks?
- Do I need to synchronize writes to memory mapped file from different threads before flushing and unmapping it?
- How to wait (vkCmdWaitEvents) 2 different events most efficiently in one cmd buffer?
- Best practice for synchronizing a changing List of the model to a ObservableList of the ViewModel?
- UWP: how to optimize synchronization between WCF WebServices and SQLite through async calls
- When does windows signal a process handle?
- Best way to synchronize my code between multiple workstations?
- requestAnimationFrame() animation of multiple objects sync problem
- Is multi-thread output from System.out.println interleaved
- How can I synchronize asyncio with other OS threads?
- Drawing from multiple threads in Qt
- Why we have to add an 'async' declaration word to the javascript function which call a sync javascript function?
- CUDA: how to use barrier.sync
- What is the synchronization cost of calling a synchronized method from a synchronized method?
- How to sync a local folder with a folder in a Google Cloud Platform bucket?