Notifications
Clear all
Topic starter
We are on centricity12.0.13 running on sql server 2008 and preparing to upgrade to 12.2.2 on sql server 2014 sp1.
Things I plan to do.
1. backup the database
2. take database offline
3. move the backup to new server
4. restore from backup
5. run DBCC UPDATEUSAGE
6. run sp_updatestats
7. set compatibility_level to 120
I am also creating a new app server so fresh install of cps, copy all the ccc and html file. Finally update all the terminal server.
I am not planning to move link logic and esm yet.
Since I am not a database administrator and I have only done this in demo environment, am I missing anything? any gotacha?
Posted : December 21, 2017 12:36 pm
Disable SQL agent backup jobs (heck disable SQL agent) that might run during your upgrade. I had that one burn me once at the very end. I had to restart a 4 hour upgrade.
-dp
Posted : December 22, 2017 4:57 am
Topic starter
thank you @SLHV, I will put that in my to do list before migration
Posted : December 22, 2017 8:44 am
Remember to run the DB Jobs in Server Setup and update your DB backup location also if you are changing it.
Posted : December 22, 2017 9:13 am
Topic starter
Does server setup re-create all the job?
Posted : December 27, 2017 12:00 pm
As I recall, it does. The backup locations revert to default, and the schedules all revert to default.
-dp
Posted : December 28, 2017 5:13 am
