Set up time isnt an issue, as you say, weekend is fine.

The issue lies with the software the clusters are supporting and the providers have which stated that we have...

Yes and that's where the issue lies as the DR (SQL instance) sits on the pre-production (windows) cluster, so yes we'd have to have that within the same cluster and...

Actually Perry its beginning to sink in and yes, that's exactly where I was getting confused...well one of the points!

Each of our clusters has 2 nodes, A/P. In order...

Am I right in thinking that if we had disk replication then we could add the other node into an availability group?

I have spent some time looking into this and...

There are 2 separate clusters, production at the main site and pre-production that has 2 SQL instances on it (pre-production and disaster recovery).

D

Thanks Perry!

Yes I did think it was still mirroring under the hood so to speak.

Here's perhaps the question, only the named instance on the 2nd cluster (DR) should be part...

No, I know what it is...sorted!

D

If you hover over an element you will see Estimated Subtree Cost - that's what you're after I believe.

I tend to use the following article:

http://technet.microsoft.com/en-us/library/ms345408.aspx

D

Yes, fully understood 🙂 Thanks Grant.

Brilliant, thanks Gail/Grant - that has put my mind at ease! 🙂

D

Grant Fritchey (1/2/2014)

---

The application name is a connection string bit of information that you can put anything in. You could say "Bob" for the application and SQL Server wouldn't know...

Actually, would a maintenance plan that is scheduled show as management studio rather than a sql agent job.

Thanks Gail that was pretty much what I thought!

Merry xmas 🙂

D

Outstanding answer sir thank you very much, clears that up!

D