The text of the original post implies to me that the delivery team are new to the technology and have a very big system to implement.

If so then you need...

• This reply was modified 2 years, 5 months ago by EdVassie. Reason: Corrected spelling mistake

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 2 years, 7 months 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 2 years, 7 months 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...