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

Backup size question

General Discussion

Last Post by DavidShower 7 years ago

3 Posts

3 Users

0 Reactions

68 Views

RSS

tnc

(@tnc)

Posts: 517

Honorable Member

Topic starter

A while back I asked a question about backup sizes, especially one in particular after an upgrade. I noticed last week that my Backup size grew by 7GB overnight. I was sort of thinking it may drop down again but that doesn't seem to be happening other than a 2GB drop the next day. We certainly could not have contributed 7GB to the database in a day as our normal average growth is. It does not seem to be a problem and I have the space (for now) but as the DB keeps growing it makes the transfer of data to my backup devices longer and the long term storage more expensive. This has only happened twice before so it shouldn't be an issue but I do like to understand what goes on with stuff like this. All of my maintenance jobs are running and did run on these dates and patch Tuesday updates were not applied until the weekend to avoid a backup-interrupting reboot.

02/19/2018 04:39 AM 96,498,392,576 CentricityPS_db_201802190359.BAK
02/20/2018 05:13 AM 96,543,384,576 CentricityPS_db_201802200436.BAK
02/21/2018 03:58 AM 103,381,887,488 CentricityPS_db_201802210318.BAK
02/22/2018 04:49 AM 101,699,295,744 CentricityPS_db_201802220338.BAK
02/23/2018 05:32 AM 101,800,698,880 CentricityPS_db_201802230450.BAK

I am certain a lot of clinics have much bigger databases and bigger challenges. I have the space for now and I will be building new servers for my next upgrade and need to try to guesstimate what kind of space I will need for the backup volume

Mike Zavolas
Tallahassee Neurological Clinic

Posted : March 2, 2018 2:12 am

Luladin

(@luladin)

Posts: 25

Eminent Member

Could be a # of things--

- Autogrow settings for data and log file kicking in.

- Reindexing job possibly rebuilt / reorganized an index increasing space consumed.

- Is your database set to full recovery? Do you have transaction log backup jobs configured?

I've seen similiar growth in our database but it's always associated with the log file and something causing a high amount of change (maintenance tasks or an upgrade)- I've never seen a 7GB increase in the data file over night.

Tracking the change now will be difficult since it already happened but there are a few SQL agent jobs out there that seem easy enough to setup- will write file size details to a temp table on a schedule and can be queried for historically reviewing file size.

- Jon

Posted : March 2, 2018 4:34 am

DavidShower

(@davidshower)

Posts: 1255

Noble Member

Also CQR and ePrescribing can add to the database. Any scheduled tasks doing CQR fixes, etc?

Posted : March 2, 2018 12:26 pm

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