Docstoc

DAT407_ Windows Server 2008 R2 andMicrosoft SQL .._1_

Document Sample
DAT407_ Windows Server 2008 R2 andMicrosoft SQL .._1_ Powered By Docstoc
					                     Windows Server 2008   Windows Server 2008 R2
                          RTM/SP2
SQL Server 2005             SP2+                   SP3+
SQL Server 2008             RTM                    SP1+
SQL Server 2008 R2          RTM                     RTM
http://technet.microsoft.com/en-us/library/ff428137(WS.10).aspx
    http://support.microsoft.com/KB/309422
http://support.microsoft.com/kb/250355
Use MSDTC instance installed to the local
group
                                                   Else


    Use the mapped instance of MSDTC
                                                          Else

        Use the cluster's default instance of
        MSDTC
                                                                 Else


             Use the local machine's instance of
             MSDTC
 Failover Initiated
                                               1. Remove not
                                         4. Remove nodes half (or
                                          2. the nodes back and
                                      3. AddUpgrade the removed more) of
  SQL 2K8 Ins
 SQL 2K8 Ins
 SQL 2K8 Ins
  SQL 2K8 Ins         SQL 2K8 Ins    upgraded, upgrade, and add possible
                                               the nodes except
                                     remove othernodes from the
 Not Upgraded
Not Upgraded
Not Upgraded
Not Upgraded           Upgraded                 back the owners
                                    the one running in instance




                                                Removed nodes cannot be
                                                failed over to until added
                                                         back in
          Setup for Failover Clustering and Microsoft Cluster
Service
                     http://www.sqlha.com/blog
SQL Server 2008 failover clustering whitepaper
Server Virtualization Validation Program
The Microsoft SQL Server support policy for Microsoft Clustering
(KB327518)
Support policy for Microsoft SQL Server products that are running in a
hardware virtualization environment (KB956893)
www.microsoft.com/teched       www.microsoft.com/learning




http://microsoft.com/technet   http://microsoft.com/msdn
    Sign up for Tech·Ed 2011 and save $500
           starting June 8 – June 31st
http://northamerica.msteched.com/registration




             You can also register at the
    North America 2011 kiosk located at registration
             Join us in Atlanta next year

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:0
posted:4/17/2013
language:Unknown
pages:32