post your statement that you are using to attach database!!!

with raid 1, you have tolerance fail!!!

forget!!!! 😀

what i said is wrong!!! only SQL 2K5!!!

really, you are greate teacher, steve!!!! good question!!!!!!!

ron, i agree with you!!! sorry, Steve!!!! you must be tired!!! the stress of work and this forum, isn't easy!!!!

nobody is perfect!!!! everyone fail!!! Steve, you are a GREAT TEACHER...

what's happening, Steve? :hehe:

well, this article: http://msdn.microsoft.com/en-us/library/bb934049.aspx

😎 i agree

Steve Jones - SSC Editor (6/28/2011)

---

My apologies, I was reading execution context and thinking query plan and wrote the wrong words. The intention was to test knowledge of the execution...

it's two differents concepts, first - Query Plans and second - Executions Context.

the article that Steve Jones said:

When a cache-able batch is submitted to SQL Server for execution, it...

i did tests to create mirror and according with print screen, i can to change the port of communication between servers!!!!

this link, by TechNet, is step-by-step to create mirror: http://technet.microsoft.com/en-us/library/ms189047.aspx

Greg,

before change of servers, you communicate using iSCSI?

what upgrade strategy you use, side-by-side or in-place?

you'll use LEFT JOINs or RIGHT JOINs in your situation!!!!

see this articile: http://msdn.microsoft.com/en-us/library/ms190014.aspx about INNER JOINs and

this: http://msdn.microsoft.com/en-us/library/ms187518.aspx about OUTER JOINs like LEF, RIGHT ....

see this document! http://msdn.microsoft.com/en-us/library/ms189852.aspx

it's overview of mirror database! and the following link: http://msdn.microsoft.com/en-us/library/ms189921.aspx for connections between servers of mirror!