Bacula-users

Re: [Bacula-users] Which tapes to put into the tape library?

2010-01-21 11:58:37
Subject: Re: [Bacula-users] Which tapes to put into the tape library?
From: "John Stoffel" <john AT stoffel DOT org>
To: "Dan Langille" <dan AT langille DOT org>
Date: Thu, 21 Jan 2010 11:30:47 -0500
Dan> I have about 100 tapes.  My tape library holds only 10 tapes.
Dan> How do you decide which tapes to load into the library?  What
Dan> strategy do you use?

I'm in the same boat, with fewer tapes, but more slots in the
library.  

Dan> Here is what I came up with.

Dan> For simplicity, all my tapes are in a single pool.  I'm guessing
Dan> I want the tapes with the oldest LastWritten value.  Something
Dan> like this:

I used to do this, but I just switched to seperate pools for
incrementals and fulls.  My feeling is that I can recycle incrementals
more aggresively, and get a better feel for when I need to recycle
older tapes.

Generally, when I run out of tapes to use, I just manually recycle my
oldest written tape and keep going.  This isn't archiving, but backups
that I need.

Of course I've got all my data on RAID1, tape backups and now
duplicity hopefully keeping stuff in sync to my brother's house in
another state.  Nothing like losing all your family photos to make the
wife mad at you, and mad at yourself.  

I should also just buy some more DLT IV tapes from Ebay as well.
They're cheap.


Dan>   SELECT mediaid, volumename, slot, volstatus, lastwritten
Dan>     FROM media
Dan>    WHERE mediatype = 'DLT'
Dan>      AND volstatus in ('Append', 'Full')
Dan> ORDER BY volstatus, lastwritten ASC
Dan>    LIMIT 20;

Dan> That gives me:

Dan>  mediaid |   volumename   | slot | volstatus |     lastwritten
Dan> ---------+----------------+------+-----------+---------------------
Dan>      268 | DGG441         |    8 | Append    |
Dan>      269 | DGG471         |    9 | Append    |
Dan>      270 | DGG465         |   10 | Append    |
Dan>      267 | DGG457         |    7 | Append    |
Dan>      263 | DGG443         |    3 | Append    |
Dan>      266 | DGG442         |    6 | Append    |
Dan>      265 | DGG469         |    5 | Append    |
Dan>      264 | DGG467         |    4 | Append    |
Dan>      262 | DGG472         |    1 | Append    |
Dan>      100 | DLT7000-001111 |    0 | Full      | 2008-12-07 14:03:20
Dan>      101 | DLT7000-JYN220 |    0 | Full      | 2008-12-17 08:16:41
Dan>      102 | DLT7000-JYN221 |    0 | Full      | 2009-01-04 07:12:47
Dan>      103 | DLT7000-JYN231 |    0 | Full      | 2009-01-10 07:22:38
Dan>      105 | DLT7000-JYN225 |    0 | Full      | 2009-02-01 08:44:52
Dan>      107 | DLT7000-JYN232 |    0 | Full      | 2009-03-01 14:44:50
Dan>      108 | DLT7000-JYN233 |    0 | Full      | 2009-03-24 13:16:00
Dan>      109 | DLT7000-JYN234 |    0 | Full      | 2009-04-05 09:49:51
Dan>      110 | DLT7000-JYN236 |    0 | Full      | 2009-04-16 12:20:04
Dan>      117 | DLT7000-JYN245 |    0 | Full      | 2009-06-13 06:11:52
Dan>      119 | DLT7000-JYN247 |    0 | Full      | 2009-06-23 06:28:06

Dan> -- 
Dan> Dan Langille -- http://langille.org/


Dan> 
------------------------------------------------------------------------------
Dan> Throughout its 18-year history, RSA Conference consistently attracts the
Dan> world's best and brightest in the field, creating opportunities for 
Conference
Dan> attendees to learn about information security's most important issues 
through
Dan> interactions with peers, luminaries and emerging and established companies.
Dan> http://p.sf.net/sfu/rsaconf-dev2dev
Dan> _______________________________________________
Dan> Bacula-users mailing list
Dan> Bacula-users AT lists.sourceforge DOT net
Dan> https://lists.sourceforge.net/lists/listinfo/bacula-users

------------------------------------------------------------------------------
Throughout its 18-year history, RSA Conference consistently attracts the
world's best and brightest in the field, creating opportunities for Conference
attendees to learn about information security's most important issues through
interactions with peers, luminaries and emerging and established companies.
http://p.sf.net/sfu/rsaconf-dev2dev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users