Hi Adelia,

My vote is to configure either Peer-to-Peer replication or Merge replication so you can form a multi-master ring.

If you're on SQL Server 2019 or later, Peer-to-Peer replication now supports...

Sure, let me know if you need more detailed solution /or script. I can help. Thanks.

Hi, I can think of this

1. Can you use Batch processing and checkpoints those batches, like a batch of 10 millions records wrapped inside a single transaction, so all or...

Hi,

You may need to give following permissions

1. Grant VIEW SERVER STATE for DMVs , Ex Query - GRANT VIEW SERVER STATE TO [YourContractorUser];
2. Grant Access in MSDB to view Jobs

USE...

Hi,

You may need to give following permissions

1. Grant VIEW SERVER STATE for DMVs , Ex Query - GRANT VIEW SERVER STATE TO [YourContractorUser];
2. Grant Access in MSDB to view Jobs

USE...

Hi,

With a Clusterless Availability Group (AG), there isn't a traditional Listener that can automatically handle failover and failback operations. Manual intervention is required for both failover and failback processes. However,...

Hi,

Could you please install sp_BlitzLock and run it for a specific duration based on the size of your database? For example, if your database is a VLDB (Very Large Database),...

Delete the schedule, click on the save button, reopen the Job, and then set a new schedule. There could be an issue with the Scheduler ID of the Job.