• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 214
  • Last Modified:

SQL upgrade from 08R2 to 2012

Hello,

I'm running SQL 08R2 on both of my servers and would like to upgrade them to 2012.  I saw there in an upgrade wizard built into 2012.  Do I simply just run that, it will check for any issues, and then let upgrade if no issues are found?

Thanks,
0
soadmin
Asked:
soadmin
  • 2
  • 2
2 Solutions
 
Aneesh RetnakaranDatabase AdministratorCommented:
you need to run the upgrade advisor first, if no issues found, you need to back up all the dbs, script jobs users etc. then run the upgrade wizard
0
 
soadminAuthor Commented:
Hello,

I know how to backup the databases, but how do you backup the script jobs, users etc?  Sorry, I'm not a DB admin so I don't understand how to do all of that.
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
you can script the jobs from enterprise manager. I totally suggest you to hire some dba to do the upgradation. it may take 5-8 hrs of work, but definitely worth it
0
 
EvilPostItCommented:
You could do a side by side installation and then migrate the jobs across using SSIS. This will also provide you with a roll back plan should anything go badly wrong.
0
 
EvilPostItCommented:
Do you require any further information?
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now