Resources for Upgrading to SQL Server 2008
Use these resources as aids in upgrading to SQL Server 2008. These references are from the downloadable white paper:
SQL Server 2008 Upgrade Technical Reference Guide
The categories in the following list correspond to chapters in the white paper.
- General Upgrade Issues
- Relational Engine Components
- Business Intelligence Components
- Other Microsoft Applications and Platforms
If there are no links for a particular section, the section is empty. As new links become available over time, those links will be added to the relevant sections. These updates will be made on an occasional basis.
General Upgrade Issues
Use these sources to support upgrade planning and deployment and upgrading the SQL Server Management Tools.
Upgrade Planning and Deployment (Chapter 1)
- Visual Studio 2008 SP1 may be required for SQL Server 2008 installations
- SQL Server 2008 installation fails when you try to install SQL Server a second time
- Cumulative update package 1 for SQL Server 2008
- An Incremental Servicing Model is available from the SQL Server team to deliver hotfixes for reported problems
- Get Ready for SQL Server 2008
- Why you should read the Release Notes for SQL Server 2008
- SQL Server 2008, Visual Studio 2008 SP1, and .Net Framework 3.5 SP1 explained...
- SQL Server 2005 Setup Fails in WOW (x86) On Computer With More Than 32 CPUs
- Upgrade for SQL Server 2008 can fail if you have renamed the 'sa' account
- SQL Server 2008 Product Overview
- Microsoft SQL Server 2008 Feature Pack: SQL Server 2008 Upgrade Assistant
- SQL Server 2008 Upgrade Assistant
- Best Practices Analyzer Tool for Microsoft SQL Server 2000 1.0
- SQL Server 2005 Best Practices Analyzer (August 2008)
- .NET Framework Downloads Web page
- Hyper-V Update for Windows Server 2008 x64 Edition (KB950050)
- Hyper-V Update for Windows Server 2008 (KB950050)
- Upgrading to Windows Server 2008
- SQL Server 2008 Jumpstart
- Microsoft Case Studies
Management Tools (Chapter 2)
Relational Engine Components
For upgrading relational engine components, use the following references:
Relational Databases (Chapter 3)
High Availability (Chapter 4)
Failover Clustering (4.1)
- Per-service SID
- Failover Clustering Configuration Program
- Network adapter teaming and server clustering
- The Microsoft SQL Server support policy for Microsoft Clustering
- How to configure an IPv6 resource for a SQL Server 2005 cluster on a Windows Server 2008-based computer
- You cannot find SQL Server cluster resources in Failover Cluster Manager after you install a SQL Server 2005 failover cluster on a computer that is running Windows Server 2008
- You cannot upgrade the operating system of a clustered server from Windows Server 2003 to Windows Server 2008
- The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 2 was released
- The Microsoft Support Policy for Windows Server 2008 Failover Clusters
- Error message when you connect to a named instance of SQL Server on a client computer that is running Windows Vista or Windows Server 2008: "Specified SQL server not found" or "Error Locating Server/Instance Specified"
- Description of the failover cluster security model in Windows Server 2008
- The MS DTC resource does not come online on a Windows Server 2008-based computer
- Failover cluster resource recovery behavior in Windows Server 2008
- The implications of using the /forcequorum switch to start the Cluster service in Windows Server 2008
- Problems occur in Windows Server 2008 after you uninstall a SQL Server 2005 failover cluster, or after you install SQL Server 2005 Service Pack 2 or a Service Pack 2-based hotfix on a SQL Server 2005 failover cluster
- Description of the Microsoft server applications that are supported on Windows Server 2008
Log Shipping (4.2)
Information will be added here as appropriate.
Database Mirroring (4.3)
Information will be added here as appropriate.
Replication (4.4)
Information will be added here as appropriate.
Other References (4.5)
- The best source for High Availability is Microsoft’s SQL Customer Advisory Team site at http://www.sqlcat.com.
- The Essential Guide to SQL Server 2005 and 2008 Failover Clustering with Windows Server 2008SQL Server Magazine
- Custom log shipping scripts from the book (available at http://www.sqlha.com/)
- Backup More Than 1GB per Second Using SQL2008 Backup Compression
Database Security (Chapter 5)
- You may receive a "Permission denied" error message when an application role-based application tries to select records from any one of the system tables in a SQL Server 2005 master database
- SQL Server, Windows Server 2008, and the Windows Firewall
- What's New for Operating System Hardening and Integrity for Windows Server 2008
- SQL Server 2008 Full-Text Search: Internals and Enhancements
- TechNet Virtual Lab: SQL Server 2008 Policy-Based Management
- SQL Server 2008 Security
Full-Text Search (Chapter 6)
- How to move, copy, and back up full-text catalog folders and files
- SQL Server 2008 Full-Text Search: Internals and Enhancements
Service Broker (Chapter 7)
Information will be added here as appropriate.
Transact-SQL Queries (Chapter 8)
Information will be added here as appropriate.
Notification Services (Chapter 9)
SQL Express/MSDE (Chapter 10)
- SQL Server 2008 Express, .Net Framework 2.0 SP2, and 3.5 SP1 explained...
- Windows Installer 4.5 Redistributable
- Microsoft .NET Framework 3.5 Service Pack 1
Business Intelligence Components
You can use the following links to support upgrading business intelligence (BI) components to SQL Server 2008:
Analysis Services (Chapter 11)
Data Mining (Chapter 12)
- Microsoft SQL Server Data Mining community site
- Jamie MacLennan: Jamie’s Junk—The official blog of the SQL Server Analysis Services Development Manager
- OLE DB for Data Mining Specification 1.0
- Bogdan Crivat: DM(X)—Bogdanc on SQL Server Data Mining
Integration Services (Chapter 13)
- New Connectivity Options in 2008
- Microsoft SQL Server 2008 Feature Pack: DTS Designer Components
- What’s New (Integration Services)
- Script Task
- Script Component
- Migrating Scripts for VSTA
- Referencing Other Assemblies in Scripting Solutions
Other References (13.1)
- Microsoft SQL Server Integration Services stuff by Douglas Laudenschlager
- Integration Services wiki
- DTS xChange
Reporting Services (Chapter 14)
Other Microsoft Applications and Platforms
SQL Server is used in other Microsoft applications and supported by other Microsoft platforms. You can use the following links to support upgrading to these other applications and platforms.
Upgrade Considerations for Other Microsoft Applications and Platforms (Chapter 15)
Microsoft Small Business Server (15.1)
- Compare Features
- Run the Migration Preparation Tool
- Migrate to Windows Small Business Server 2008 from Windows Small Business Server 2003
- Prepare your Source Server for migration
- Optional post-migration tasks
- Wrap up of SBS/EBS announcements from World Wide Partner Conference
- Microsoft Windows Essential Server Solutions Web page
Microsoft Office Communications Server (15.2)
- Microsoft Office Communications Server 2007: Database Topologies
- Microsoft Office Communications Server 2007
Microsoft Office SharePoint Server (MOSS) 2007 (15.3)
- Determine hardware and software requirements (Windows SharePoint Services)
- Determine hardware and software requirements (Office SharePoint Server)
- Migration and Upgrade Resource Center for SharePoint Server 2007
- Migrate databases
Microsoft System Center 2007 (15.4)
- Microsoft System Center
- Microsoft SQL Server Management Pack for Microsoft Operations Manager 2005
- Microsoft System Center: Data Protection Manager
- System Center Data Protection Manager 2007 Feature Pack (x64)
- How to protect SQL SERVER with DPM 2007
Microsoft Dynamics (15.5)
Information will be added here as appropriate.