Dears,we have a huge table with a clustered index and 6 non-clustered indexes, when we create this index in the past there is one of our processes -which executes on this table- took as an example about 10 minutes to complete, after a week later , th...
Dears, kindly help in this issue,recently I noted that our database has some tables with columns of text datatype, but some of those tables has 0 rows, so I am wondering if I change datatype for those columns to varchar, so:1- to what length can I se...
Dears,
we have a warm standby replication between db1 (primary) and db2 (standby) and a MSA replication between WS logical connection and db3(standby in far way), every thing was fine, and the data synchronization is fine, suddenly the replication ...
Dears, kindly help in the following: we have a MSA replication between two databases where the whole primary database is set as database replication definition, yesterday, someone logged in to the subscription databases and added some records to one ...
Kindly advice me when we have two replication servers how or when transactions fare removed from the primary replication server ?
In our case even transactions applied in the destination database, the queues not purg its content
It almost will be...
thanks for replyingreferring to my comment above, there is no issue with truncation point as data is removed from queues related to warm standby replication.to be more specific, the problem is related to a route's queue, and then it become related to...
Thanks for replyingactually, both of the two configs: save_interval and dsi_non_blocking_commit (from admin config result) is zero,I should add something that the primary replication server RS1 manages a Warm standby replication and the related stabl...
Dear Markkindly note that we did the steps mentioned above with no success, we did them in the following order:at RS2:1. sqm_purg_queue2. suspend connection to RDB3. resume connection to RDB skip to resync markerwe checked admin disk_space and notice...
Dear Mark,you are right! In the table rs_repdbs, there was a record for the database that related to the subscription , we deleted it manually,so the defining subscription executed on the primary rep server, and things fineafter that, , Actually a bi...
