Solved

SQL upgrade from 08R2 to 2012

Posted on 2013-06-25
5
198 Views
Last Modified: 2016-02-11
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
Comment
Question by:soadmin
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 39276457
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
 

Author Comment

by:soadmin
ID: 39276476
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
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 250 total points
ID: 39276500
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
 
LVL 16

Assisted Solution

by:EvilPostIt
EvilPostIt earned 250 total points
ID: 39278325
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
 
LVL 16

Expert Comment

by:EvilPostIt
ID: 39293248
Do you require any further information?
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how the fundamental information of how to create a table.

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question