Planning SQL Server Upgrade

Leave a comment (1) Go to comments
What questions you should ask prior to decide / plan a SQL Server Upgrade.

I recently got a requirement to build a list of questionnaire which a DBA should have answer prior to work on any SQL Server Upgrade projcet. Here are few notes

  1. What is the requirement for upgrade?
  2. What are current bottlenecks?
  3. What are expectations from upgrade?
  4. Know Infrastructure environment
  5. Know the application environment
  6. Expected downtime which is acceptable to business during upgrade?
  7. Is this In-place upgrade or new Hardware will be used for upgrade?
  8. Know the SQL Server Inventory which includes
    1. Windows environment where SQL Server is hosted
    2. Hardware
    3. Software Inventory should cover all SQL Components like
      1. Database Engine Components
      2. Analysis Services
      3. Reporting Services etc

For Example, here are few points which should be considered for Database Engine Inventory

  1. Database information
  2. Security Information, Authentication mechanism, Security Policies etc
  3. All other components and dependencies
    1. iv.      Service Broker etc
    2. v.      SOAP
    3. vi.      Linked Servers
    4. vii.      MSDTC
    5. viii.      DTS
    6. DR / High availability strategy which are currently deployed
      1. ix.      Clustering
      2. x.      Replication
      3. xi.      Mirroring
      4. xii.      Log shipping
      5. xiii.      Snapshots
      6. xiv.      SAN replication etc
    7. SQL Server Utilization / Load
    8. Scheduled Tasks
    9. Administrative Contacts etc..

EOF - Planning SQL Server Upgrade, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000
Leave a comment


  1. Isa there any particlar steps for upgrading sql server2005(SSRS) to sql server 2008(SSRS)

Leave a Reply

Your email address will not be published. Required fields are marked *


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.