Tuesday, May 12, 2009

Re: Millennium Database question

Linda,

We are also on Millennium (version 7.7.1) and ours takes up approx.
1.5 GB. Each SQL backup of it takes up that much space, too. The
entire server can hold something like 136 GB. It's in two
partitions. Space has not been a problem for us. The same server is
our file server for Word / Excel / other docs used by anyone in
Development. The twice-daily SQL backups of the Mill database are
only retained on the server for five days at a time, so that means we
have ten SQL backups sitting on the server (so, 15 GB). By then we
have five nightly Arcserve tape backups where those SQL backups have
been saved, so there is no need to retain all the old SQL
backups. It's set up in SQL so that the old .BAK files just
automatically get deleted after five days.

At our site we have one tape in the server each day and nine others
in the fire safe, so we can access the past nine days pretty
easily. On the first day of each month, the tape is taken out of the
rotation, stored off site, and replaced with a new tape.

I don't think you have posted your question to the Millennium
listserve -- are you a member of it? Based on old postings, it looks
like Betsy Argo and Chris Coyan are in the Mill listserve; maybe they
could post the question on behalf of Columbus School for Girls, if
you don't want to join another listserve. However, I have found the
Mill listserve very helpful, so maybe you'd like to consider joining
it; I'd even say that the community of Mill users is one great
"feature" of Mill.

Hope this helps,

Peggy Dolter
<mdolter@jburroughs.org>
Development Office
John Burroughs School
St. Louis, Missouri

[ For info on ISED-L see http://www.gds.org/ISED-L ]
Submissions to ISED-L are released under a creative commons, attribution, non-commercial, share-alike license.
RSS Feed, http://listserv.syr.edu/scripts/wa.exe?RSS&L=ISED-L