DBI 319 http blogs msdn comsearchresults aspx q
DBI 319
http: //blogs. msdn. com/searchresults. aspx? q= slipstream§ions=11606
Demo
Upgrade Strategies and Considerations Stand-alone Upgrade
SQL Server 2005 SP 2 SQL Server 2008 SP 2 SQL Server 2000 SP 4 SQL Server 2008 SQL Server 2005 SP 4 SQL Server 2008 R 2 SQL Server Denali
Demo
SQL Server 2005/2008 Instance SQL Server Denali Instance Compare and Verify. Verified!
Upgrade Strategies and Considerations Cluster Upgrade
Active Passive
Step 3: a) Install prerequisites and upgrade shared features b) Reboot, if prompted Active Step 1: a) Install prerequisites and upgrade shared features b) Reboot, if prompted SQL Instance Manual Failover Step 2: a) Fail over to the upgrade node Passive
Step 4: Upgrade to SQL Server 2008 R 2 on passive node SQL Server 2008 R 2 Removed from Cluster Group Possible Owners Passive Active Step 5: Upgrade to SQL Server 2008 R 2 on active node No client connection for 1 -2 minutes SQL Server 2008 R 2 Active Step 6: Setup performs the failover
Upgrade Strategies and Considerations Database Mirroring
1. Upgrade Mirror First 2. Wait for Low Activity Window 4. Failover to Mirror: (New Principal) 3. ALTER Mode to SYNCHRONOUS 5. ALTER Mode to ASYNCHRONOUS 6. UPGRADE New Mirror Instance Asynchronous Mirroring: Steps 1 -6 Synchronous Mirroring: Steps 1, 4, 6
Step 4: failovereach to the 2: Manually Manual Failover database mirroring partner for each to mirroring partner database Step 1: Upgrade mirrored instance SQL Server 2008 R 2 Mirrored Principal SQL Step 3: Upgrade cluster to SQL Server 2008 R 2 SQL Server Cluster Mirroring resumed suspended Active SQL Server 2008 R 2 Passive
Upgrade Strategies and Considerations Log Shipping
Upgrade Strategies and Considerations Feature-Specific Information
www. dtsxchange. com
Upgrade Tools with Demos
Available through SQL Server Installation Center, on source media, and through SQL Server Feature Pack Demo
http: //blogs. msdn. com/b/petersad/archive/2011/05/05/installing-sql-server 2008 -best-practice-analyzer-bpa-on-a-non-domain-machine. aspx
Demo
Demo
http: //msdn. microsoft. com/enus/library/dd 981032. aspx
Demo
Demo
Upgrade Resources
http: //www. microsoft. com/sqlserver/2008/en/us/upgrade. aspx http: //msdn. microsoft. com/en-us/library/bb 677622. aspx http: //www. microsoft. com/downloads/details. aspx? Family. ID=66 d 3 e 6 f 5 -6902 -4 fdd-af 759975 aea 5 bea 7&displaylang=en http: //msdn. microsoft. com/en-us/sqlserver/bb 671050. aspx http: //blogs. msdn. com/b/petersad/ http: //technet. microsoft. com/en-us/library/bb 510662. aspx
http: //www. microsoft. com/downloads/details. aspx? displaylang=en&Family. ID=ceb 4346 f-657 f-4 d 28 -83 f 5 aae 0 c 5 c 83 d 52 http: //www. microsoft. com/map http: //www. microsoft. com/downloads/en/details. aspx? Family. Id=DA 0531 E 4 -E 94 C-4991 -82 FA-F 0 E 3 FBD 05 E 63 http: //www. microsoft. com/downloads/en/details. aspx? Family. ID=0 fd 439 d 7 -4 bff-4 df 7 -a 52 f-9 a 1 be 8725591 http: //msdn. microsoft. com/en-us/library/bb 677181. aspx http: //blogs. msdn. com/b/petersad/archive/2011/05/10/cluster-upgrade-sql-server-2008 -r 2 -gt-sql-server-denali. aspx
DBI 302 DBI 404 DBI 373 -INT
. NET 3. 5 SP 1 Notes SQL 2008/2008 R 2 Denali Available through WU as an important update or the Download Center. Not included in Vista/Win 2008 by default, installation requires a reboot Needed by all features, Setup will install Setup does not install and will block if needed and not installed. Required by Reporting Services. Setup installs from installation media N/A Setup does not install and will block if needed and not installed. Required by Database Engine and Management Tools. Only Express Core 2008 SP 1 or Express Core 2008 R 2 supports Setup will install. Required by all features, except Report Services. N/A Setup will block if not installed KB 937444 N/A Power Shell 1. 0 Power Shell 2. 0 Available through WU as a recommended update or the Download Center. Not included in Vista/Win 2008 by default, installation requires a reboot . NET 4. 0 Critical update for. NET 2. 0/3. 5 Windows 2003 Critical Update KB 956250 available through WU and Download Center
http: //blogs. msdn. com/b/petersad/archive/2011/01/24/how-to-perform-an-sqlserver-edition-upgrade. aspx
www. scalabilityexperts. com/ssua
Visit the updated website for SQL Server® Code Name “Denali” on www. microsoft. com/sqlserver and sign to be notified when the next CTP is available Follow the @SQLServer Twitter account to watch for updates Try the new SQL Server Mission Critical Bare. Metal Hand’s on-Labs Visit the SQL Server Product Demo Stations in the DBI Track section of the Expo/TLC Hall. Bring your questions, ideas and conversations! • Microsoft® SQL Server® Security & Management • Microsoft® SQL Server® Programmability • Microsoft® SQL Server® Mission Critical • Microsoft® SQL Server® Optimization and Scalability • Microsoft® SQL Server® Data Warehousing • Microsoft® SQL Server® Data Integration
Resources Connect. Share. Discuss. http: //northamerica. msteched. com Sessions On-Demand & Community Microsoft Certification & Training Resources www. microsoft. com/teched www. microsoft. com/learning Resources for IT Professionals Resources for Developers http: //microsoft. com/technet http: //microsoft. com/msdn
To access more details on this session, capture this TAG
- Slides: 60