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 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 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...

Things are a lot easier with Enterprise Edition. IMHO the HA capabilities of EE make it worth paying the additional price. Trying to roll your own stuff compared to having...

By now I hope you have read about what a CXSYNC_PORT wait is. If not please do so.

The situation described for this wait type did exist in SQL2014, but was...

Removed, duplicate post.

• This reply was modified 2 years, 2 months ago by EdVassie.