server upgrade

• fawwad

  SSC Eights!

  Points: 965

  More actions

  April 9, 2011 at 7:51 am

  #234683

  Hello All,

  I have to upgrade my clients SQL server 2000 and SQL server 2005 to SQL server 2008 R2

  please tell me, should i do this with upgrade wizard or i must uninstall SQL server 2000 and SQL server 2005 and then install SQL server 2008 ?

  I want to retrieve all my login and SQL jobs ? how is this possible

• SQLRNNR

  SSC Guru

  Points: 281334

  More actions

  April 9, 2011 at 8:01 am

  #1309538

  You could use the upgrade assistant. I would look into doing a side by side upgrade so as to have a fallback option.

  Jason...AKA CirqueDeSQLeil
  _______________________________________________
  I have given a name to my pain...MCM SQL Server, MVP
  SQL RNNR
  Posting Performance Based Questions - Gail Shaw[/url]
  Learn Extended Events

• fawwad

  SSC Eights!

  Points: 965

  More actions

  April 9, 2011 at 8:04 am

  #1309540

  thanks for the post

  upgrade assistance may help us in choosing right configuration for upgrade.

  but i m more concerned with my current databases, logins and sql jobs.

  if i upgrade to SQL server 2008 R2 , do i get all the stuff or i may have to reconfigure those things again ?