[Bacula-users] Using bsr files to restore / re-catalog DB

2007-10-29 Thread Janco van der Merwe
Hi,

I hope someone can help me with this one.

Someone approached me to help with their Bacula but the guy who set it
up has left and they are in a bit of a sticky situation.

First the nitty gritty:
Bacula 1.38.1 with MySQL
RHEL 4
Using a Dell PV-124T with LTO3

These people have different backups pools namely -
Daily with 10 volumes 
Weekly with 4 volumes
Monthly with 36 volumes and should have had a volume retention period of
1095 days because they keep the Monthly backups for three years

The client wants to restore a file on a volume that is 1 year old and
because the File, job and volume retentions were specified incorrectly
the entire job was purged from the catalog, a long with other monthly
backup jobs, and I have no reference of those Volumes or jobs in the
catalog except for the bsr files.

Is there a way that I can restore files from that volume using the bsr
files or one better, can I use the bsr files to rebuild the catalog and
set the correct retention periods where applicable and if that is
possible how will I go about doing it?

I tried searching the net, the user list and the manual for similar
situations but was unable to find anything.

Can anyone help me or GENTLY point out that it is in the manual and that
I missed it?  


-- 
Janco van der Merwe
Open Solutions
Tel: 011 305 2887
Cell: 083 291 8536
Fax: 0866978875
__
Think not those faithful who praise all thy words and actions; but those
who kindly reprove thy faults.
Socrates




-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Using bsr files to restore / re-catalog DB

2007-10-29 Thread Michael Lewinger
Hi janco,

I think the right command are bscan and bextract, pp 485 on the latest
printed manual, pp 513 on the PDF.

Cheers'

michael lewinger

On 10/29/07, Janco van der Merwe [EMAIL PROTECTED] wrote:

 Hi,

 I hope someone can help me with this one.

 Someone approached me to help with their Bacula but the guy who set it
 up has left and they are in a bit of a sticky situation.

 First the nitty gritty:
 Bacula 1.38.1 with MySQL
 RHEL 4
 Using a Dell PV-124T with LTO3

 These people have different backups pools namely -
 Daily with 10 volumes
 Weekly with 4 volumes
 Monthly with 36 volumes and should have had a volume retention period of
 1095 days because they keep the Monthly backups for three years

 The client wants to restore a file on a volume that is 1 year old and
 because the File, job and volume retentions were specified incorrectly
 the entire job was purged from the catalog, a long with other monthly
 backup jobs, and I have no reference of those Volumes or jobs in the
 catalog except for the bsr files.

 Is there a way that I can restore files from that volume using the bsr
 files or one better, can I use the bsr files to rebuild the catalog and
 set the correct retention periods where applicable and if that is
 possible how will I go about doing it?

 I tried searching the net, the user list and the manual for similar
 situations but was unable to find anything.

 Can anyone help me or GENTLY point out that it is in the manual and that
 I missed it?


 --
 Janco van der Merwe
 Open Solutions
 Tel: 011 305 2887
 Cell: 083 291 8536
 Fax: 0866978875
 __
 Think not those faithful who praise all thy words and actions; but those
 who kindly reprove thy faults.
 Socrates




 -
 This SF.net email is sponsored by: Splunk Inc.
 Still grepping through log files to find problems?  Stop.
 Now Search log events and configuration files using AJAX and a browser.
 Download your FREE copy of Splunk now  http://get.splunk.com/
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users




-- 
Michael Lewinger
MBR Computers
http://mbrcomp.co.il
-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now  http://get.splunk.com/___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Using bsr files to restore / re-catalog DB

2007-10-29 Thread Arno Lehmann
Hello,

29.10.2007 09:34,, Janco van der Merwe wrote::
 Hi,
 
 I hope someone can help me with this one.
 
 Someone approached me to help with their Bacula but the guy who set it
 up has left and they are in a bit of a sticky situation.

Always a bad thing, especially if they don't have good enough 
documentation :-)

 First the nitty gritty:
 Bacula 1.38.1 with MySQL
 RHEL 4
 Using a Dell PV-124T with LTO3
 
 These people have different backups pools namely -
 Daily with 10 volumes 
 Weekly with 4 volumes
 Monthly with 36 volumes and should have had a volume retention period of
 1095 days because they keep the Monthly backups for three years
 
 The client wants to restore a file on a volume that is 1 year old and
 because the File, job and volume retentions were specified incorrectly
 the entire job was purged from the catalog, a long with other monthly
 backup jobs, and I have no reference of those Volumes or jobs in the
 catalog except for the bsr files.

Do you have the bsr files that were current when the files they want 
back were backed up?

A recent bsr file won't help you as it doesn't reference older backups.

 Is there a way that I can restore files from that volume using the bsr
 files or one better, can I use the bsr files to rebuild the catalog and
 set the correct retention periods where applicable and if that is
 possible how will I go about doing it?

I assume you don't have the old bsr files for now.

 I tried searching the net, the user list and the manual for similar
 situations but was unable to find anything.
 
 Can anyone help me or GENTLY point out that it is in the manual and that
 I missed it?  

:-)
Ok, I try to be very gently...

First, you should know which tapes you need.

If you've absolutely no idea which tapes the jobs are on, you have 
some work before you.

First, see if they archive the job report mails or the console log - 
both are excellent sources to search for the relevant volume names.

Once you've got the volumes, you can use bls to see their contents.

If you want the contents back in the catalog, you'd use bscan, but 
only after you fixed the retention times,reloaded the configuration, 
and probably set the volume attributes so they reflect the retention 
times you really want.

If you don't want the whole stuff in the catalog again, with the 
output from bls, you can use bextract to locally store the needed 
files to disk.

Does this help you, or do you want some more details?

(By the way - there was a discussion started by Maria McKinley a while 
ago, with the subject old recovery. I think you'll find valuable 
information in there. That's the most recent elaboration of the 
solutions to this sort of problems, I think.)

Arno

 

-- 
Arno Lehmann
IT-Service Lehmann
www.its-lehmann.de

-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Using bsr files to restore / re-catalog DB

2007-10-29 Thread janco
Thanks guys, I'll try and let you know how it worked out.

 Hello,

 29.10.2007 09:34,, Janco van der Merwe wrote::
 Hi,

 I hope someone can help me with this one.

 Someone approached me to help with their Bacula but the guy who set it
 up has left and they are in a bit of a sticky situation.

 Always a bad thing, especially if they don't have good enough
 documentation :-)

 First the nitty gritty:
 Bacula 1.38.1 with MySQL
 RHEL 4
 Using a Dell PV-124T with LTO3

 These people have different backups pools namely -
 Daily with 10 volumes
 Weekly with 4 volumes
 Monthly with 36 volumes and should have had a volume retention period of
 1095 days because they keep the Monthly backups for three years

 The client wants to restore a file on a volume that is 1 year old and
 because the File, job and volume retentions were specified incorrectly
 the entire job was purged from the catalog, a long with other monthly
 backup jobs, and I have no reference of those Volumes or jobs in the
 catalog except for the bsr files.

 Do you have the bsr files that were current when the files they want
 back were backed up?

 A recent bsr file won't help you as it doesn't reference older backups.

 Is there a way that I can restore files from that volume using the bsr
 files or one better, can I use the bsr files to rebuild the catalog and
 set the correct retention periods where applicable and if that is
 possible how will I go about doing it?

 I assume you don't have the old bsr files for now.

 I tried searching the net, the user list and the manual for similar
 situations but was unable to find anything.

 Can anyone help me or GENTLY point out that it is in the manual and that
 I missed it?

 :-)
 Ok, I try to be very gently...

 First, you should know which tapes you need.

 If you've absolutely no idea which tapes the jobs are on, you have
 some work before you.

 First, see if they archive the job report mails or the console log -
 both are excellent sources to search for the relevant volume names.

 Once you've got the volumes, you can use bls to see their contents.

 If you want the contents back in the catalog, you'd use bscan, but
 only after you fixed the retention times,reloaded the configuration,
 and probably set the volume attributes so they reflect the retention
 times you really want.

 If you don't want the whole stuff in the catalog again, with the
 output from bls, you can use bextract to locally store the needed
 files to disk.

 Does this help you, or do you want some more details?

 (By the way - there was a discussion started by Maria McKinley a while
 ago, with the subject old recovery. I think you'll find valuable
 information in there. That's the most recent elaboration of the
 solutions to this sort of problems, I think.)

 Arno



 --
 Arno Lehmann
 IT-Service Lehmann
 www.its-lehmann.de

 -
 This SF.net email is sponsored by: Splunk Inc.
 Still grepping through log files to find problems?  Stop.
 Now Search log events and configuration files using AJAX and a browser.
 Download your FREE copy of Splunk now  http://get.splunk.com/
 ___
 Bacula-users mailing list
 Bacula-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/bacula-users




-
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now  http://get.splunk.com/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users