I used the below also I set it to disable certain jobs if it was the secondary too, so when failing over all of this was automatic.

Simply set the...

You cannot have FCI + AG on two nodes. This is a three node minimum setup.

The FCI will...

If the plan is to stop P1 and P2 then the databases on the 3rd replica will be in restoring mode. They can be brought online by using the WITH...

JarJar (10/6/2016)

---

We are doing a DRP test on a large database, which is hosted on an AlwaysOn availablilty group with 3 replicas (2 sync, 1 async). The plan is...

You will need a minimum of 3 servers to achieve FCI+AG.

Server A and B will be the FCI. Only 1 can be run AO Replica 1 (Primary AO)

Server C AO...

Thanks Wayne.

Thanks all.

Hi,

This is usually a AD\SPN issue which I normally pass onto my Windows Admins.

Are you using KERBEROS for authentication?

TALIB

Thanks All.

Much Appreciated!!!

Thanks for taking the time all

Conversions or functions on columns; is the most likely with this piece of code.

This is what I thought but just needed to get a second...

I'm talking about row estimates

I have seen issues when the reporting services service spikes and remains @100 Percentage for no logical reason as nothing is running . Did you check how much CPU...

Sounds like it may have cached a bad execution plan.

Are you looking after PRODUCTION SQL servers?

Are you considering installing an instance on a PRODUCTION SQL Server?

Always-on will fix page repairs automatically the same as mirroring.

https://msdn.microsoft.com/en-us/library/bb677167.aspx

Not sure what you are trying to set up here. That a regular CHECKDB with FULL,Tlog backups and Always...