I just finished rereading the "Restoring Files Can Be Slow" section of 
the manual. In it, it mentions doing a restore will be about 3 times 
slower than a backup.

Now I've got a situation where I have to remove sensitive data that was 
backed up on several tapes. The way I'm doing this is to bscan a tape so 
as to sync the content to a new catalog, then restore each Jobs in 
seperate restore jobs. Once every job has been restored, I search for 
the sensitive data, delete and then backup every seperate jobs in one 
single job.

So basically I've got a /backup-restore folder that contains each 
seperate jobs in their own folder (ie. /backup-restore/01, 
/backup-restore/02, ... /backup-restore/98). I need to do this in order 
to prevent files with the same name to overwrite each other. Once I 
deleted the sensitive data, I backup the parent (/backup-restore) folder 
in a single job.

The problem I'm having with this is that it took 5 days to only do the 
restore of each jobs. I had 98 jobs that bscan found and added to the 
catalog, all of which are about 100MB to 30GB in size. Here are the 
actual stats:

|    99 | RestoreFiles           | 2007-06-10 13:16:54 | R    | F     
|      839 |  9,375,175,662 | T         |
|   100 | RestoreFiles           | 2007-06-10 13:21:59 | R    | F     
|    1,726 | 13,753,356,353 | T         |
|   101 | RestoreFiles           | 2007-06-10 13:34:53 | R    | F     
|    1,294 |  7,507,618,432 | T         |
|   102 | RestoreFiles           | 2007-06-10 13:48:45 | R    | F     
|       69 |  2,698,552,655 | T         |
|   103 | RestoreFiles           | 2007-06-10 14:04:24 | R    | F     
|      181 |  1,124,735,587 | T         |
|   104 | RestoreFiles           | 2007-06-10 14:19:41 | R    | F     
|      185 |  6,962,747,990 | T         |
|   105 | RestoreFiles           | 2007-06-10 14:37:07 | R    | F     
|       77 |    163,609,625 | T         |
|   106 | RestoreFiles           | 2007-06-10 14:53:16 | R    | F     
|       69 |        254,471 | T         |
|   107 | RestoreFiles           | 2007-06-10 15:09:25 | R    | F     
|       81 |      2,552,629 | T         |
|   108 | RestoreFiles           | 2007-06-10 15:25:30 | R    | F     
|       27 |         56,330 | T         |
|   109 | RestoreFiles           | 2007-06-10 15:41:40 | R    | F     
|       27 |    386,932,859 | E         |
|   110 | RestoreFiles           | 2007-06-10 15:57:58 | R    | F     
|       45 |    400,472,872 | E         |
|   111 | RestoreFiles           | 2007-06-10 16:14:27 | R    | F     
|        2 |              0 | T         |
|   112 | RestoreFiles           | 2007-06-10 16:30:58 | R    | F     
|        1 |              0 | T         |
|   113 | RestoreFiles           | 2007-06-10 16:47:34 | R    | F     
|       25 |         47,614 | T         |
|   114 | RestoreFiles           | 2007-06-10 17:04:11 | R    | F     
|      120 |  1,456,639,525 | T         |
|   115 | RestoreFiles           | 2007-06-10 17:21:20 | R    | F     
|      115 |    924,184,944 | E         |
|   116 | RestoreFiles           | 2007-06-10 17:39:05 | R    | F     
|       24 |  2,012,746,608 | T         |
|   117 | RestoreFiles           | 2007-06-10 17:57:56 | R    | F     
|       22 |  5,516,879,617 | E         |
|   118 | RestoreFiles           | 2007-06-10 18:19:14 | R    | F     
|       39 |        156,034 | T         |
|   119 | RestoreFiles           | 2007-06-10 18:40:33 | R    | F     
|    2,088 | 29,390,128,004 | T         |
|   120 | RestoreFiles           | 2007-06-10 19:16:14 | R    | F     
|    1,740 | 28,320,759,453 | T         |
|   121 | RestoreFiles           | 2007-06-10 20:02:00 | R    | F     
|       90 | 10,878,922,296 | T         |
|   122 | RestoreFiles           | 2007-06-10 20:48:38 | R    | F     
|      170 |  2,252,300,718 | T         |
|   123 | RestoreFiles           | 2007-06-10 21:36:43 | R    | F     
|       82 |  1,178,566,819 | T         |
|   124 | RestoreFiles           | 2007-06-10 22:24:34 | R    | F     
|      634 | 17,735,540,399 | T         |
|   125 | RestoreFiles           | 2007-06-10 23:20:25 | R    | F     
|    1,188 | 13,807,451,886 | T         |
|   126 | RestoreFiles           | 2007-06-11 00:22:03 | R    | F     
|      791 | 16,694,460,936 | T         |
|   127 | RestoreFiles           | 2007-06-11 01:31:54 | R    | F     
|       60 |  2,634,776,786 | T         |
|   128 | RestoreFiles           | 2007-06-11 02:42:21 | R    | F     
|      101 |  1,090,378,050 | T         |
|   129 | RestoreFiles           | 2007-06-11 03:52:46 | R    | F     
|       57 |  1,124,468,166 | T         |
|   130 | RestoreFiles           | 2007-06-11 05:03:28 | R    | F     
|      339 |  8,835,238,851 | T         |
|   131 | RestoreFiles           | 2007-06-11 06:17:57 | R    | F     
|      856 |  4,534,089,836 | T         |
|   132 | RestoreFiles           | 2007-06-11 07:34:35 | R    | F     
|      462 |  4,147,681,004 | E         |
|   133 | RestoreFiles           | 2007-06-11 08:52:52 | R    | F     
|       59 |  2,659,671,701 | T         |
|   134 | RestoreFiles           | 2007-06-11 10:12:02 | R    | F     
|       94 |    465,811,129 | T         |
|   135 | RestoreFiles           | 2007-06-11 11:30:35 | R    | F     
|       37 |     46,173,056 | T         |
|   136 | RestoreFiles           | 2007-06-11 12:49:02 | R    | F     
|      265 |    158,593,004 | T         |
|   137 | RestoreFiles           | 2007-06-11 14:07:25 | R    | F     
|    1,158 | 12,304,604,808 | T         |
|   138 | RestoreFiles           | 2007-06-11 15:31:22 | R    | F     
|      721 | 11,870,205,869 | E         |
|   139 | RestoreFiles           | 2007-06-11 16:59:47 | R    | F     
|       35 |     48,282,434 | T         |
|   140 | RestoreFiles           | 2007-06-11 18:26:27 | R    | F     
|       88 |  1,097,258,620 | T         |
|   141 | RestoreFiles           | 2007-06-11 19:53:54 | R    | F     
|       57 |  1,128,283,570 | T         |
|   142 | RestoreFiles           | 2007-06-11 21:21:58 | R    | F     
|      309 |  8,869,302,807 | T         |
|   143 | RestoreFiles           | 2007-06-11 22:54:37 | R    | F     
|    1,034 | 11,027,999,542 | T         |
|   144 | RestoreFiles           | 2007-06-12 00:33:17 | R    | F     
|      775 | 10,071,559,072 | T         |
|   145 | RestoreFiles           | 2007-06-12 02:14:35 | R    | F     
|       59 |  2,668,992,214 | T         |
|   146 | RestoreFiles           | 2007-06-12 03:57:00 | R    | F     
|      101 |  1,115,268,249 | T         |
|   147 | RestoreFiles           | 2007-06-12 05:39:14 | R    | F     
|       57 |  1,131,586,973 | T         |
|   148 | RestoreFiles           | 2007-06-12 07:21:41 | R    | F     
|      328 |  8,844,804,369 | T         |
|   149 | RestoreFiles           | 2007-06-12 09:08:38 | R    | F     
|    1,428 | 27,400,036,182 | T         |
|   150 | RestoreFiles           | 2007-06-12 11:11:40 | R    | F     
|    1,291 | 26,112,839,218 | T         |
|   151 | RestoreFiles           | 2007-06-12 13:23:10 | R    | F     
|       81 |  5,305,668,932 | T         |
|   152 | RestoreFiles           | 2007-06-12 15:34:21 | R    | F     
|       79 |  2,191,612,160 | T         |
|   153 | RestoreFiles           | 2007-06-12 17:46:15 | R    | F     
|       79 |  2,271,817,442 | T         |
|   154 | RestoreFiles           | 2007-06-12 19:58:35 | R    | F     
|      141 | 17,292,801,400 | T         |
|   155 | RestoreFiles           | 2007-06-12 22:18:55 | R    | F     
|      236 |     21,629,455 | T         |
|   156 | RestoreFiles           | 2007-06-13 00:38:42 | R    | F     
|      273 |     14,355,447 | T         |
|   157 | RestoreFiles           | 2007-06-13 02:58:24 | R    | F     
|       18 |     75,080,730 | T         |
|   158 | RestoreFiles           | 2007-06-13 05:18:06 | R    | F     
|      223 |     14,687,611 | T         |
|   159 | RestoreFiles           | 2007-06-13 07:37:56 | R    | F     
|      195 |     72,471,671 | T         |
|   160 | RestoreFiles           | 2007-06-13 09:57:41 | R    | F     
|        1 |              0 | T         |
|   161 | RestoreFiles           | 2007-06-13 12:17:54 | R    | F     
|       50 |     23,114,683 | T         |
|   162 | RestoreFiles           | 2007-06-13 14:37:43 | R    | F     
|        1 |              0 | T         |
|   163 | RestoreFiles           | 2007-06-13 16:57:38 | R    | F     
|      182 |    326,636,492 | T         |
|   164 | RestoreFiles           | 2007-06-13 19:17:40 | R    | F     
|      768 |    134,524,492 | T         |
|   165 | RestoreFiles           | 2007-06-13 21:37:54 | R    | F     
|      594 |  1,620,308,574 | T         |
|   166 | RestoreFiles           | 2007-06-13 23:58:50 | R    | F     
|       60 |  2,638,023,267 | T         |
|   167 | RestoreFiles           | 2007-06-14 02:21:14 | R    | F     
|       89 |    147,264,741 | T         |
|   168 | RestoreFiles           | 2007-06-14 04:44:46 | R    | F     
|       59 |  1,121,178,889 | T         |
|   169 | RestoreFiles           | 2007-06-14 07:09:30 | R    | F     
|      309 |    302,171,355 | T         |
|   170 | RestoreFiles           | 2007-06-14 09:35:56 | R    | F     
|    1,054 | 12,525,796,261 | T         |
|   171 | RestoreFiles           | 2007-06-14 12:10:56 | R    | F     
|      874 | 12,536,819,303 | T         |
|   172 | RestoreFiles           | 2007-06-14 14:47:43 | R    | F     
|       59 |  2,656,967,307 | T         |
|   173 | RestoreFiles           | 2007-06-14 17:22:42 | R    | F     
|      101 |  1,104,317,462 | T         |
|   174 | RestoreFiles           | 2007-06-14 19:57:03 | R    | F     
|       52 |    289,243,570 | E         |
+-------+------------------------+---------------------+------+-------+----------+----------------+-----------+

Am I doing this the most efficient way possible? Is it normal that each 
job takes progressively longer to complete? I'm getting the feeling the 
tape is rewinding and forward spacing a lot for nothing since I'm trying 
to restore every job on tape.

Any advice or comments would be appreciated.

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Reply via email to