SQL Server 2005: Server upgrade requirements

• Determine your product version upgrade path.
• See "Version and Edition Upgrades" in SQL Server 2005 Books Online

• Verify that the SQL Server 2005 environment meets hardware and software requirements.
• See Hardware and Software Requirements for Installing SQL Server 2005

• Ensure that the SQL Server 2005 environment is capable of supporting future needs from a user and transaction perspective.
• Review your legacy SQL Server configurations and objects using SQL Server 2005 Upgrade Advisor to determine potential issues prior to the upgrade. This Microsoft tool is valuable to understanding issues in the environment.
• See Using Upgrade Advisor to Prepare for Upgrades and the SearchSQLServer.com tip Reduce upgrade unknowns with SQL Server 2005 Upgrade Advisor

• Set up an ...
  
  To continue reading for free, register below or login

  Requires Membership to View

  To gain access to this and all member only content, please provide the following information:

  Email Address:
  
  
  

  By joining SearchSystemsChannel.com you agree to receive email updates from the TechTarget network of sites, including updates on new content, magazine or event notifications, new site launches and market research surveys. Please verify all information and selections above. You may unsubscribe at any time from one or more of the services you have selected by editing your profile or unsubscribing via email.
  
  TechTarget cares about your privacy. Read our Privacy Policy
  To read more you must become a member of SearchSystemsChannel.com

  As an existing member of the TechTarget network please activate your SearchSystemsChannel.com account 

  By joining SearchSystemsChannel.com you agree to receive email updates from the TechTarget network of sites, including updates on new content, magazine or event notifications, new site launches and market research surveys. Please verify all information and selections above. You may unsubscribe at any time from one or more of the services you have selected by editing your profile or unsubscribing via email.
  
  TechTarget cares about your privacy. Read our Privacy Policy
  
  
  

  Digg This!     StumbleUpon     Del.icio.us

  
  
  
  

  RELATED CONTENT Database Deployment and Upgrade Projects The changing database consolidation landscape Maintaining performance after a database consolidation Refining plans for database consolidation Cleaning up with database consolidation services Oracle Database 11g innovations: Get ahead of the game Remote DBA services: Overcoming sales hurdles Computer information systems for small and midsized businesses (SMBs) Web-based database support DBA services can make VARs money Architectural solutions to Web-based applications with large datasets for VARs SQL Server Upgrade Microsoft SQL Server migration to SQL Server 2005 SQL Server 2005 migration methods SQL Server upgrade: Moving to SQL Server 2005 Server Installation and Upgrades Installing and managing Hyper-V on Windows Server 2008 Server Core Microsoft System Center Configuration Manager 2007 pre-installation tips Microsoft System Center Configuration Manager 2007 installation steps VMware extends vSphere Enterprise Edition availability Windows Server 2008 Server Core installation Configuring Windows Server 2008 Server Core Upgrading to energy-efficient servers Planning a SharePoint 2003 to SharePoint 2007 migration SharePoint 2003 to SharePoint 2007 pre-migration tasks Server virtualization technology guide

  RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

  
  
  environment to test the migration process as well as front-end applications and dependent (upstream and downstream) systems' functionality.

• Take a holistic view of the environment to ensure you don't overlook any applications because the components that are overlooked become issues during the process.

Click for the next tip to help you prepare for a SQL Server 2005 upgrade: Common SQL Server 2005 upgrade methods

This tip originally appeared on SearchSQLServer.com.

About the author: Jeremy Kadlec is the Principal Database Engineer at Edgewood Solutions, a technology services company delivering professional services and product solutions for Microsoft SQL Server. He has authored numerous articles and delivers frequent presentations at regional SQL Server Users Groups and nationally at SQL PASS. Jeremy is also SearchSQLServer.com's Performance Tuning expert. Ask him a question.

Rate this Tip To rate tips, you must be a member of SearchSystemsChannel.com. Register now to start rating these tips. Log in if you are already a member. DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.