Upgrading SQL 2005 to sql 2008 r2

Question

question

clayp56 asked Mar 21, '12

Upgrading SQL 2005 to sql 2008 r2

When doing an upgrade from SQL 2005 to SQL 2008 r2 will I need to recreate all the SQL Agent jobs? If yes, is there an automated process ? Not looking forward to recreating all the jobs. thanks,

sql-server-2008-r2

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2012-03-21T14:01:50Z

WilliamD answered Mar 21, '12

If you perform an in-place upgrade then the jobs will remain and you won't have to do anything special. The upgrade is done on the installed 2005 instance and requires some system downtime. This is the easiest route if the server can be taken offline. It is risky in case the upgrade fails (for whatever reason) and takes the instance offline for an unknown amount of time. If you are doing a fresh install on a new box, you will need to backup/script out the jobs and transfer them across to the new instance. This has the advantage of allowing you to do the upgrade/install any time and then transfer once the instance is up and running.

3

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

clayp56 commented · Mar 21, 2012 at 02:10 PM

Thanks! I am going to save the scripts for each job just in case. I appreciate your help!

0 ·

clayp56 commented · Mar 21, 2012 at 02:12 PM

By the way, do I need to make a copy of all the SSIS and SSRS projects before upgrading as well?

0 ·

WilliamD commented · Mar 21, 2012 at 02:28 PM

SSIS and SSRS can also be upgraded through an in-place upgrade. I am not too sure about migration of those to a new machine, but believe it would run similarly to job migration (namely script out and re-deploy).

0 ·

question