We take a full backup of the database every Sunday, which we retain for 30
days. We take a differential backup of the database every night, these are
retained for 7 days. We take a log backup of the database every 15 minutes,
which are retained for 24 hours.
All the backups are stored on a separate server. The database server has a
snapshot taken every night as well.
We also take special full backups of the database every month that we
retain for a year, and a full backup on NYE that we retain indefinitely.
On Wed, Aug 21, 2019, 9:19 AM Parsell, David <[log in to unmask]> wrote:
> We back up the database and the images nightly.
>
> The backups are kept for about a week.
>
> We have the luxury of a large IT infrastructure at Yale University so they
> handle the backup storage details.
>
> The only times we have had to restore a backup have occurred during a TMS
> upgrade when we had to scratch the upgrade and start over.
>
> Whether you are a small or large museum, a nightly backup is the minimum
> requirement and you need to get the backups off-site.
>
> If you were in the midst of extensive cataloging or image ingest, I would
> recommend a 2nd backup at lunchtime.
>
> David Parsell
>
> Yale Center for British Art
> ------------------------------
> *From:* The Museum System (TMS) Users <[log in to unmask]> on
> behalf of April Brown <[log in to unmask]>
> *Sent:* Tuesday, August 20, 2019 4:47 PM
> *To:* [log in to unmask] <[log in to unmask]>
> *Subject:* TMS backups
>
>
> Hi,
>
> We just had an issue with how our backups were being done by our
> contract IT person (we don’t have a dedicated person on-site). I have a few
> questions about how other museums handle this issue. Our database is not
> hosted by TMS.
>
>
>
> 1. How often do you do backups of the database?
>
> 2. How long do you keep the backups?
>
> 3. Where are the backups stored?
>
> 4. When you do the backups is it just of the database or do you
> include the file server (where all the media files etc. are stored), is
> that on a different schedule or is everything kept together?
>
>
>
> We just recently switched to TMS and so all these processes are new to us,
> as our other system had an integrated backup which the Collections
> Department would handle, rather than having it managed by an outside IT
> person.
>
>
>
> Thanks so much for any help on this topic,
>
>
>
> *April Brown*
> *Registrar *
> The Charles Hosmer Morse Museum of American Art
> Phone: (407) 645-5311 x. 105 | Fax: (407) 647-1284
>
> https://nam02.safelinks.protection.outlook.com/?url=www.morsemuseum.org&data=02%7C01%7CTMSUSERS%40si-listserv.si.edu%7Cc7766bbfd1a84d79fb1708d7265bf2aa%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C637020048678047104&sdata=5BODCdSI0Qb6o74aviEIGyafoImS0uCUsv9SJvRslkc%3D&reserved=0
> <https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.morsemuseum.org%2F&data=02%7C01%7CTMSUSERS%40si-listserv.si.edu%7Cc7766bbfd1a84d79fb1708d7265bf2aa%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C637020048678047104&sdata=ouyoZzzfo00pd2%2BAf2xn0QQWxrBZJPwk4IHWaqgaLS8%3D&reserved=0>
>
>
> To unsubscribe, send an email to [log in to unmask] with the
> following commands in the body of the email:
>
> signoff TMSUSERS
>
> // eoj
>
> You will receive a confirmation that your subscription has been removed.
> To unsubscribe, send an email to [log in to unmask] with the
> following commands in the body of the email:
>
> signoff TMSUSERS
>
> // eoj
>
> You will receive a confirmation that your subscription has been removed.
>
To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.