To answer some of the question. So I have five database that were already replicated to a reporting sql server using pull subscription.

We are migrating to virtual server to...

Issue can be simulated with the below script.

create table nat ( c1 int identity(1,1) primary key,c2 int)

declare @a int=1

...

yes, its part of a DB which is part of availability group

Hi,

Have you checked the error log. Looks like a resource issue on the mirror. we had a similar issue where the mirror was low and memory and the...

Hello,

If i understand correctly, you are planning on a mirrored subscriber. if that is the case, and there is a failover of the subscription database, then you would have...

Hi

its normal that the log usage is high during index rebuild. you can try bulk logged recovery if you want to lower the transaction log usage during index rebuild,...

ALTER DATABASE [dbname] MODIFY FILE ( NAME = filename, SIZE = 900MB )

the above is the command. the current size of the file is 800MB. but even after...

i guess the log reader agent is timing out... u can try to reduce the batch size in log reader agent profile.

We have the same issue and it works....

Instead of shrinking in one shot, try shrinking in small batches.. may be 2Gb at a time or even 1GB...

I've also some across this issue where it takes forever...