DB's structure

I would consider this database “big”. If this was mine, I would consider strategies to segment it into two or three smaller databases. I would not plan to keep growing indefinitely. See Bill’s article here for some related thoughts.

As databases grow, maintenance and backup is increasingly important: 1/ remove unneeded data or rarely-used files by moving them to an archive. 2/ frequent Verify & Repair. 3/ occasional rebuild. 4/ occasional export of all contents to an external drive. 5/ regular backup to multiple destinations, especially off-site.