Bacula-users

Re: [Bacula-users] Exchange plugin: Unable to restore

2010-11-05 04:58:38
Subject: Re: [Bacula-users] Exchange plugin: Unable to restore
From: Graham Keeling <graham AT equiinet DOT com>
To: Michael Heydenbluth <news.only AT hm-dat DOT de>
Date: Fri, 5 Nov 2010 08:55:12 +0000
On Thu, Nov 04, 2010 at 08:52:18PM +0100, Michael Heydenbluth wrote:
> Graham Keeling schrieb:
> 
> > On Thu, Nov 04, 2010 at 03:34:35PM +0100, Michael Heydenbluth wrote:
> > > Hello,
> > > 
> > > I'm trying to backup/restore an Exchange database.
> > > 
> > > Following configuration:
> > > W2K3 R2 Server (32) with Exchange 2003 SP2, bacula-fd 5.0.3 from the
> > > download area,
> > > bacula-sd and bacula-dir (5.0.3 - mysql) compiled from source to
> > > run on SLES 9.
> > > 
> > >[short description of commands I entered]
> 
> > Can you copy and paste the exact commands that you enter, and the
> > output of them?
> 
> Here we go. Sorry it's bit long, but you asked for it :-):
> 
> (just to be sure, there's nothing executing right now):
> *status director
> 
> sqlbsrv1-dir Version: 5.0.3 (04 August 2010) i686-pc-linux-gnu suse 9
> Daemon started 03-Nov-10 15:08, 18 Jobs run since started.
>  Heap: heap=946,176 smbytes=167,123 max_bytes=2,761,470 bufs=564
> max_bufs=5,473
> 
> Scheduled Jobs:
> Level          Type     Pri  Scheduled          Name Volume
> ===================================================================================
> [10 jobs or so scheduled to run at 11:00pm]
> 
> Running Jobs:
> Console connected at 04-Nov-10 20:16
> No Jobs running.
> ====
> 
> Terminated Jobs:
>  JobId  Level    Files      Bytes   Status   Finished        Name
> ====================================================================
> 1205                0         0   Cancel   04-Nov-10 14:10 RestoreFiles
> 1206                0         0   Cancel   04-Nov-10 14:17 RestoreFiles
> 1207                0         0   Cancel   04-Nov-10 14:52 RestoreFiles 
> 1208                0         0   Cancel   04-Nov-10 15:50 RestoreFiles
> 
> ====
> 
> *status storage=SuperLoader3
> Connecting to Storage daemon SuperLoader3 at sqlbsrv1:9103
> 
> sqlbsrv1-sd Version: 5.0.3 (04 August 2010) i686-pc-linux-gnu suse 9
> Daemon started 03-Nov-10 15:08. Jobs: run=15, running=0.
>  Heap: heap=421,888 smbytes=161,927 max_bytes=342,749 bufs=114
> max_bufs=202
> Sizes: boffset_t=8 size_t=4 int32_t=4 int64_t=8
> 
> Running Jobs:
> No Jobs running.
> ====
> 
> Jobs waiting to reserve a drive:
> ====
> 
> Terminated Jobs:
>  JobId  Level    Files      Bytes   Status   Finished        Name
> ===================================================================
> [...]
> 1205                0         0   Cancel   04-Nov-10 14:10 RestoreFiles
> 1206                0         0   Cancel   04-Nov-10 14:17 RestoreFiles
> 1207                0         0   Cancel   04-Nov-10 14:52 RestoreFiles
> 1208                0         0   Cancel   04-Nov-10 15:50 RestoreFiles
> ====
> 
> Device status:
> Autochanger "Autochanger" with devices:
>    "LTO-4" (/dev/nst1)
> Device "FileStorage" (/bacula) is not open.
> Device "LTO-4" (/dev/nst1) is mounted with:
>     Volume:      KYE718L4
>     Pool:        WinServer
>     Media type:  LTO-4
>     Slot 6 is loaded in drive 0.
>     Total Bytes Read=151,151,616 Blocks Read=2,343 Bytes/block=64,512
>     Positioned at File=212 Block=2,343
> 
> Used Volume status:
> KYE718L4 on device "LTO-4" (/dev/nst1)
>     Reader=0 writers=0 devres=0 volinuse=0
> ====
> 
> Data spooling: 0 active jobs, 0 bytes; 1 total jobs, 2,304,272,492 max
> bytes/job. Attr spooling: 0 active jobs, 2,436,193 bytes; 1 total jobs,
> 2,436,193 max bytes.
> ====
> 
> *restore
> Automatically selected Catalog: MyCatalog
> Using Catalog "MyCatalog"
> 
> First you select one or more JobIds that contain files
> to be restored. You will be presented several methods
> of specifying the JobIds. Then you will be allowed to
> select which files from those JobIds are to be restored.
> 
> To select the JobIds, you have the following choices:
>      1: List last 20 Jobs run
>      2: List Jobs where a given File is saved
>      3: Enter list of comma separated JobIds to select
> [...]
>     13: Cancel
> Select item:  (1-13): 3
> Enter JobId(s), comma separated, to restore: 1200
> 
> You have selected the following JobId: 1200
> 
> Building directory tree for JobId(s) 1200 ...
> ++++++++++++++++++++++++++++++++++++++++++++++ 24,089 files inserted
> into the tree.
> 
> You are now entering file selection mode where you add (mark) and
> remove (unmark) files to be restored. No files are initially added,
> unless you used the "all" keyword on the command line.
> Enter "done" to leave this mode.
> 
> cwd is: /
> $ cd "/@EXCHANGE/Microsoft Information Store/Erste Speichergruppe/"
> cwd is: /@EXCHANGE/Microsoft Information Store/Erste Speichergruppe/
> $ ls
> C:\Programme\Exchsrvr\mdbdata\E0002449.log
> C:\Programme\Exchsrvr\mdbdata\E000244A.log
> C:\Programme\Exchsrvr\mdbdata\E000244B.log
> C:\Programme\Exchsrvr\mdbdata\E000244C.log
> C:\Programme\Exchsrvr\mdbdata\E000244D.log
> C:\Programme\Exchsrvr\mdbdata\E000244E.log
> C:\Programme\Exchsrvr\mdbdata\E000244F.log
> C:\Programme\Exchsrvr\mdbdata\E0002450.log
> C:\Programme\Exchsrvr\mdbdata\E0002451.log
> C:\Programme\Exchsrvr\mdbdata\E0002452.log
> C:\Programme\Exchsrvr\mdbdata\E0002453.log
> C:\Programme\Exchsrvr\mdbdata\E0002454.log
> C:\Programme\Exchsrvr\mdbdata\E0002455.log
> C:\Programme\Exchsrvr\mdbdata\E0002456.log
> Informationsspeicher f▒r ▒ffentliche Ordner (DMS)/
> Postfachspeicher (DMS)/
> $ mark "Postfachspeicher (DMS)/"
> 4 files marked.
> $ cd "Postfachspeicher (DMS)"
> $ ls
> *D:\MDBDATA\priv1.edb
> *D:\MDBDATA\priv1.stm
> *DatabaseBackupInfo
> $ done
> Bootstrap records written to /var/run/bacula/sqlbsrv1-dir.restore.9.bsr
> 
> The job will require the following
>    Volume(s)                 Storage(s)                SD Device(s)
> ===========================================================================
> 
>    *KYE718L4                  SuperLoader3              LTO-4
> 
> Volumes marked with "*" are online.
> 
> 
> 7 files selected to be restored.
> 
> Defined Clients:
>      2: dms-fd
> [...]
> Select the Client (1-10): 2
> Run Restore job
> JobName:         RestoreFiles
> Bootstrap:       /var/run/bacula/sqlbsrv1-dir.restore.9.bsr
> Where:           /tmp/bacula-restores
> Replace:         always
> FileSet:         Linux RootDir
> Backup Client:   dms-fd
> Restore Client:  dms-fd
> Storage:         SuperLoader3
> When:            2010-11-04 20:34:13
> Catalog:         MyCatalog
> Priority:        10
> Plugin Options:  *None*
> OK to run? (yes/mod/no): yes
> Job queued. JobId=1209
> * 
> You have messages.
> *mess
> 04-Nov 20:37 sqlbsrv1-dir JobId 1209: Start Restore Job
> RestoreFiles.2010-11-04_20.37.00_12 
> 04-Nov 20:37 sqlbsrv1-dir JobId 1209: Using Device "LTO-4" *
> 04-Nov 20:38 sqlbsrv1-sd JobId 1209: Ready to read from volume
> "KYE718L4" on device "LTO-4" (/dev/nst1). 
> 04-Nov 20:38 sqlbsrv1-sd
> JobId 1209: Forward spacing Volume "KYE718L4" to file:block 212:0.
> 
> 04-Nov 20:39 dms-fd JobId 1209: Fatal error: Invalid restore path
> specified, must start with '/@EXCHANGE/'

I've not seen that error message before, so maybe I'm not going to be much
help.

But I think you're supposed to mark all the mdbdata log files at the same
time.
Also, have you tried marking /@EXCHANGE from the top level and restoring
everything altogether?
And you need to make sure that...
Informationsspeicher f▒r ▒ffentliche Ordner (DMS)/
Postfachspeicher (DMS)/
...are dismounted and have the 'can be overwritten by a restore' magic tickbox
ticked.
Another thing that I have found is that, when things go wrong, you can
sometimes end up with files left in a 'restore' directory inside
C:\Programme\Exchsrvr\mdbdata, and they get in the way of subsequent restores.

Sorry I'm not more help.


> *status director
> [...]
> Running Jobs:
> Console connected at 04-Nov-10 20:16
>  JobId Level   Name                       Status
> ======================================================================
>   1209         RestoreFiles.2010-11-04_20.37.00_12 is waiting on
> Storage SuperLoader3 ====
> [...]
> 
> *cancel
> Automatically selected Job: JobId=1209
> Job=RestoreFiles.2010-11-04_20.37.00_12 Confirm cancel (yes/no): yes
> 
> 
> > By the way, I have found out that it is very easy to crash the file
> > daemon when running the Exchange plugin, and it is not always obvious.
> > Whenever anything goes wrong, it is a good idea to check that it is
> > still running. Restarting the director helps too.
> 
> In my case it doesn't seem to crash. It seems to me, it just doesn't
> pass a sanity check. I get the same result every time, whether the
> daemons were just restarted or running for a while.
> 
> 
> 
> 
> ------------------------------------------------------------------------------
> The Next 800 Companies to Lead America's Growth: New Video Whitepaper
> David G. Thomson, author of the best-selling book "Blueprint to a 
> Billion" shares his insights and actions to help propel your 
> business during the next growth cycle. Listen Now!
> http://p.sf.net/sfu/SAP-dev2dev
> _______________________________________________
> Bacula-users mailing list
> Bacula-users AT lists.sourceforge DOT net
> https://lists.sourceforge.net/lists/listinfo/bacula-users


------------------------------------------------------------------------------
The Next 800 Companies to Lead America's Growth: New Video Whitepaper
David G. Thomson, author of the best-selling book "Blueprint to a 
Billion" shares his insights and actions to help propel your 
business during the next growth cycle. Listen Now!
http://p.sf.net/sfu/SAP-dev2dev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
<Prev in Thread] Current Thread [Next in Thread>