We use RS in Warm Standby configuration one of the databases had a problem today and there was a large number of rows generated that we not needed. As a result I truncated the table on the primary side. the problem is that the data still seems to be flowing through the repserver to the database on the warm standby side. The queue for this Db has been increasing in size all day and is now alomst 10 GB.
So I wanted to find out if there any way to delete the data ?
I attached a file with the output of the admin who, sqm & admin who,sqt commands.