The text of the original post implies the delivery team are new to the technology and have a large system to deliver.

If so then you need far more help than...

I hope your applications are connecting to your databases via DNS aliases. Using DNS aliases as a layer of indirection drastically simplifies the impact of making the type of move...

My advice is to work on the suggestions of sscoach. Setup some tables in your test system that reproduce your problem with the minimum number of tables and data.

Also follow...

I just noticed, have you created a SPN for the listener name

A listener works by creating a DNS entry that points to your server. It should also create a listener entry within your SQL Server instances to tie the two together.

Are...

The curse of working in computing is that the only constant is change. The skill that will command top dollar one year may not command any job at all five...

I certainly agree that the Missing Index data in SQL Server is useful but not something that should be applied without further investigation.

One thing to consider is if a non-clustered...

I totally agree with all aspects of Jeff's response.

The error reported by the OP has sometimes happened to me when applying a CU to a clustered SQL instance.

The work-round in Jeffrey Williams post shows the process we had...

If you like Upgrade in Place then you will love Russian Roulette. Both have the same level of randomness about when they will kill the subject.

I would never do an...

I have just seen this thread.  Even though it is now solved it may be useful to look at the process I documented in SQL FineBuild for SQL Agent proxy...

• This reply was modified 1 year, 1 month ago by  EdVassie. Reason: Corrected spelling mistake

I have just seen this thread. Even though it is now solved it might be useful to refer to the process I documented in SQL FineBuild about setting up SQL...

In case you did not pick up the crucial bit from the previous post, data stored as ntext must get converted to nvarchar.

If you go from ntext to plain old...

• This reply was modified 1 year, 1 month ago by  EdVassie.

Ant-Green has the right idea.

I have seen a number of sites where the system engineers (or a dedicated backup team) are using agent processes to take backups of everything.  This...

Start with the RTO and RPO of the databases. This will guide you on the backup scenario you need. Having the databases in an AG makes no difference to what...