Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

sql server 2014

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

6 Posts

2 Users

0 Reactions

71 Views

RSS

amaskey

(@amaskey)

Posts: 88

Estimable Member

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

SLHV

(@slhv)

Posts: 478

Honorable Member

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

amaskey

(@amaskey)

Posts: 88

Estimable Member

Topic starter

thank you @SLHV, I will put that in my to do list before migration

Posted : December 22, 2017 8:44 am

SLHV

(@slhv)

Posts: 478

Honorable Member

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

amaskey

(@amaskey)

Posts: 88

Estimable Member

Topic starter

Does server setup re-create all the job?

Posted : December 27, 2017 12:00 pm

SLHV

(@slhv)

Posts: 478

Honorable Member

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

Share:

24 Forums
9,940 Topics
39.9 K Posts
0 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0