SQL Server upgradation

Question

SQL Server upgradation

jitendra.padhiyar

SSCertifiable

Points: 5824
More actions
May 15, 2012 at 1:42 pm

#261352

Hello Masters,
During upgradation, all the user database will be upgraded to new version, but what will happen to system databases and Scheduled tasks and jobs? How would we upgrade them to new version? Are they automatically upgraded ?

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Ignacio A. Salom Rangel SSC-Insane Points: 20443 More actions · Answer 1

jitendra.padhiyar (5/15/2012)
Hello Masters,
During upgradation, all the user database will be upgraded to new version, but what will happen to system databases and Scheduled tasks and jobs? How would we upgrade them to new version? Are they automatically upgraded ?

Check this. 😉

My blog

SQLisAwe5oMe SSChampion Points: 14052 More actions · Answer 2

jitendra.padhiyar (5/15/2012)
Hello Masters,
During upgradation, all the user database will be upgraded to new version, but what will happen to system databases?
When you install newer version, system databases comes with it. System databases are part of the architecture of SQL Server, so it should come with installation.
and Scheduled tasks and jobs? How would we upgrade them to new version? Are they automatically upgraded ?

Any server level informations such as logins, alerts, jobs, etc.....needs to be script it out and apply to the new server.

Hope I was able to answer your question. Let me know if you need anything additional.

TA.

Regards,
SQLisAwe5oMe.

Ant-Green SSC Guru Points: 113507 More actions · Answer 3

SQLCrazyCertified (5/16/2012)
jitendra.padhiyar (5/15/2012)
Hello Masters,
During upgradation, all the user database will be upgraded to new version, but what will happen to system databases?
When you install newer version, system databases comes with it. System databases are part of the architecture of SQL Server, so it should come with installation.
and Scheduled tasks and jobs? How would we upgrade them to new version? Are they automatically upgraded ?
Any server level informations such as logins, alerts, jobs, etc.....needs to be script it out and apply to the new server.
Hope I was able to answer your question. Let me know if you need anything additional.
TA.

True for a side by side upgrade, but what about an in place upgrade?

Steve Jones - SSC Editor SSC Guru Points: 736430 More actions · Answer 4

If you do an in place upgrade, your system databases are upgraded. You should not have issues with linked servers, but job, maintenance plans and SSIS packages could potentially have an issue, depending on what you've programmed in them. If there is code you've added that is not compatible with the new version, they would error out.

SQLisAwe5oMe SSChampion Points: 14052 More actions · Answer 5

SQLCrazyCertified (5/16/2012)
jitendra.padhiyar (5/15/2012)
Hello Masters,
During upgradation, all the user database will be upgraded to new version, but what will happen to system databases?
When you install newer version, system databases comes with it. System databases are part of the architecture of SQL Server, so it should come with installation.
and Scheduled tasks and jobs? How would we upgrade them to new version? Are they automatically upgraded ?
Any server level informations such as logins, alerts, jobs, etc.....needs to be script it out and apply to the new server.
Hope I was able to answer your question. Let me know if you need anything additional.
TA.

Well, in place upgrade there are no rollback plan....so, you need to plan accordingly. You need to have complete backup of the databases and document all the necessary information before you upgrade. These things should be done during the planning process.

Regards,

TA

Regards,
SQLisAwe5oMe.

Ant-Green SSC Guru Points: 113507 More actions · Answer 6

SQLCrazyCertified (5/16/2012)
SQLCrazyCertified (5/16/2012)
jitendra.padhiyar (5/15/2012)
Hello Masters,
During upgradation, all the user database will be upgraded to new version, but what will happen to system databases?
When you install newer version, system databases comes with it. System databases are part of the architecture of SQL Server, so it should come with installation.
and Scheduled tasks and jobs? How would we upgrade them to new version? Are they automatically upgraded ?
Any server level informations such as logins, alerts, jobs, etc.....needs to be script it out and apply to the new server.
Hope I was able to answer your question. Let me know if you need anything additional.
TA.
Well, in place upgrade there are no rollback plan....so, you need to plan accordingly. You need to have complete backup of the databases and document all the necessary information before you upgrade. These things should be done during the planning process.
Regards,
TA

You could build a rollback plan in by taking an image of the server before hand with something like Ghost or Acronis, also as you said backup the DB's and ship them somewhere before hand. Another rollback would be to uninstall the higher version and reinstall the lower version and then restore the databases. Granted gets very messy but can be done.

SQLisAwe5oMe SSChampion Points: 14052 More actions · Answer 7

anthony.green (5/16/2012)
SQLCrazyCertified (5/16/2012)
SQLCrazyCertified (5/16/2012)
jitendra.padhiyar (5/15/2012)
Hello Masters,
During upgradation, all the user database will be upgraded to new version, but what will happen to system databases?
When you install newer version, system databases comes with it. System databases are part of the architecture of SQL Server, so it should come with installation.
and Scheduled tasks and jobs? How would we upgrade them to new version? Are they automatically upgraded ?
Any server level informations such as logins, alerts, jobs, etc.....needs to be script it out and apply to the new server.
Hope I was able to answer your question. Let me know if you need anything additional.
TA.
Well, in place upgrade there are no rollback plan....so, you need to plan accordingly. You need to have complete backup of the databases and document all the necessary information before you upgrade. These things should be done during the planning process.
Regards,
TA
You could build a rollback plan in by taking an image of the server before hand with something like Ghost or Acronis, also as you said backup the DB's and ship them somewhere before hand. Another rollback would be to uninstall the higher version and reinstall the lower version and then restore the databases. Granted gets very messy but can be done.

good to know.

Thanks,

TA

Regards,
SQLisAwe5oMe.