from top of my head

1st statement will allow you to use snapshot isolation level when specified i.e. SET TRANSACTION ISOLATION....
2nd will make it your default isolation level

Thanks Steve,

I Wrote pre and post deployment scripts to deal with this.
Pre deployment script drops all table articles leaving the replication in place and Post deployment adds...

you should backup principal, you can use either Olas scripts, maintenance plans or write your own.

Set up a backup solution of your choice on both servers and make...

what is your backup strategy? how often do you take transaction log backups?

it must be down to you using SQL collation.

Here you might find the answer to your question

... For example, if you are using...

Hi,

Just to let you know, taking fresh FULL backup helped.

Yes, I take my backups with checksum and RESTORE VERIFYONLY straight after that, I'm using Ola's scripts. I was thinking of taking another Full backup today after working hours.

I've tried on 2 different servers

No, it won't

but the Insert/update will try to obtain an exclusive lock on the index in order to update it as well.

Will AlwaysOn just start itself after upgrade or do i have to set it up again?

Thank you Gail, Is there anything to keep in mind out of ordinary when upgrading?

When i was doing some testing in 2016 I've noticed that Catch-All queries (ones from...

Thank you Iwas,

Really appreciate the feedback 🙂 I've updated it recently fixing some minor things.

First i want to find out if there is a known functionality in sql server that can handle it, if not then i will create a solution to handle it.

Thank you Joe! I will look into it.