Yeah, that is what I thought but I can't seem to see anything related to blocking - only CPU thresholds, IO alerts and few others. Looks like we will have...

Thanks Sue.

So, confusingly, you have to set the option for schema changes to be disabled - then they get copied over in the fresh snapshot? Ok I will...

Yes - I was talking about the option you set in SQL server network properties in Config Manager.
Your thoughts actually reflect what I initially said when this was proposed,...

Have you considered Transactional Replication? If you know the tables you need to report from, you can just choose those tables to be involved in the replication.Any changes to the...

Hi
Thanks to everyone for their help and suggestions. I have managed to fix the issue. I simply moved the tempdb files (6 files plus the log) to a newly...

Ok thanks Sue.
So from reading those articles, it seems that things would be worse if using mirroring or always On AG groups.
It mentions for Log shipping that the...