On Mon, Sep 01, 2008 at 12:03:59PM +0200, Daniel Betz wrote:
> Hi Matthias,
>
> you can try to use mtimeonly in the FileSet Resource to backup these files:
> http://bacula.org/en/rel-manual/Configuring_Director.html#SECTION001470000000000000000
>
> mtimeonly=yes|no
> If enabled, tells the Client that the selection of files during
> Incremental and Differential backups should based only on the st_mtime value
> in the stat() packet. The default is no which means that the selection of
> files to be backed up will be based on both the st_mtime and the st_ctime
> values. In general, it is not recommended to use this option.
>
> I dont know if this work, but you can give it an try.
>
> Greetings,
>
> Daniel Betz
> Platform Engineer
> ___________________________________
>
> domainfactory GmbH
> Oskar-Messter-Str. 33
> 85737 Ismaning
> Germany
>
> Telefon: +49 (0)89 / 55266-364
> Telefax: +49 (0)89 / 55266-222
>
> E-Mail: dbetz AT df DOT eu
> Internet: www.df.eu
>
> Registergericht: Amtsgericht München
> HRB 150294, Geschäftsführer Tobias
> Marburg, Jochen Tuchbreiter
>
>
> > -----Ursprüngliche Nachricht-----
> > Von: bacula-users-bounces AT lists.sourceforge DOT net [mailto:bacula-users-
> > bounces AT lists.sourceforge DOT net] Im Auftrag von Matthias Baake
> > Gesendet: Montag, 1. September 2008 10:50
> > An: bacula-users AT lists.sourceforge DOT net
> > Betreff: [Bacula-users] Incremental/Differential Backup MSSQL
> > Vertraulichkeit: Vertraulich
> >
> > Hello *,
> >
> > I have a few problems with backing up MSSQL Database/Log Files. The
> > Main problem seems to be that the file size and timestamp are not
> > getting updated for a longer term(about some days). The Database is
> > running
> > 24/7 and the database is written/updated everyday but still the File
> > Size and timestamp remain the same. Is there another way for bacula to
> > detect file changes, or does anyone else got this problem?
> >
> > Sincerly
> >
> > --
> > Matthias Baake
> > - Systemadministration -
> > MarcanT InterNet-Services GmbH
> > Ravensberger Str 10 G
> > D - 33 602 Bielefeld
> > Fon: +49 5 21 - 9 59 45 - 0
> > Fax: +49 5 21 - 9 59 45 - 18
> > E-Mail: mbaake AT marcant DOT net
> > URL: http://www.marcant.net
> >
> > Geschäftsführer: Thorsten Hojas
> > Handelsregister: Amtsgericht Bielefeld, HRB 35 827 USt-ID Nr.: DE
> > 190203238
> >
> > ___________________________________________________________
> > VERTRAULICHKEITSHINWEIS:
> > Der Inhalt dieser E-Mail ist vertraulich und fuer den Nutzer der EMail
> > Adresse bestimmt, an den die Nachricht geschickt wurde; sie kann
> > darueber hinaus durch besondere Bestimmungen geschuetzt sein. Wenn Sie
> > nicht der Adressat dieser EMail sind, duerfen Sie diese nicht
> > kopieren, weiterleiten, weitergeben oder sie ganz oder teilweise in
> > irgendeiner Weise nutzen. Wenn Sie diese EMail faelschlicherweise
> > erhalten haben, benachrichtigen Sie bitte den Absender, indem Sie auf
> > diese Nachricht antworten.
> >
> > ___________________________________________________________
> > CONFIDENTIALITY NOTICE
> > The contents of this email are confidential to the ordinary user of
> > the email address to which it was addressed and may also be
> > privileged. If you are not the addressee of this email you may not
> > copy, forward, disclose or otherwise use it or any part of it in any form
> > whatsoever.
> > If you have received this email in error please email the sender by
> > replying to this message.
> >
> >
> > ----------------------------------------------------------------------
> > -
> > --
> > This SF.Net email is sponsored by the Moblin Your Move Developer's
> > challenge Build the coolest Linux based applications with Moblin SDK &
> > win great prizes Grand prize is a trip for two to an Open Source event
> > anywhere in the world
> > http://moblin-contest.org/redirect.php?banner_id=100&url=/
> > _______________________________________________
> > Bacula-users mailing list
> > Bacula-users AT lists.sourceforge DOT net
> > https://lists.sourceforge.net/lists/listinfo/bacula-users
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> Bacula-users mailing list
> Bacula-users AT lists.sourceforge DOT net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
Hi Daniel,
i do not think that this will be the solution. The Timestamp of the
files are not getting updated properly. Maybe this is a MSSQL
internal. I think the MSSQL Server allocates a chunk of space and
writes until it allocates another. Thats the only possibility for that
behavior. The question is, got somebody smiliar problems with MSSQL
Backups?
sincerly
--
Matthias Baake
- Systemadministration -
MarcanT InterNet-Services GmbH
Ravensberger Str 10 G
D - 33 602 Bielefeld
Fon: +49 5 21 - 9 59 45 - 0
Fax: +49 5 21 - 9 59 45 - 18
E-Mail: mbaake AT marcant DOT net
URL: http://www.marcant.net
Geschäftsführer: Thorsten Hojas
Handelsregister: Amtsgericht Bielefeld, HRB 35 827
USt-ID Nr.: DE 190203238
___________________________________________________________
VERTRAULICHKEITSHINWEIS:
Der Inhalt dieser E-Mail ist vertraulich und fuer den Nutzer der EMail Adresse
bestimmt, an den die Nachricht geschickt wurde; sie kann darueber hinaus durch
besondere Bestimmungen geschuetzt sein. Wenn Sie nicht der Adressat dieser
EMail sind, duerfen Sie diese nicht kopieren, weiterleiten, weitergeben oder
sie ganz oder teilweise in irgendeiner Weise nutzen. Wenn Sie diese EMail
faelschlicherweise erhalten haben, benachrichtigen Sie bitte den Absender,
indem Sie auf diese Nachricht antworten.
___________________________________________________________
CONFIDENTIALITY NOTICE
The contents of this email are confidential to the ordinary user of the email
address to which it was addressed and may also be privileged. If you are not
the addressee of this email you may not copy, forward, disclose or otherwise
use it or any part of it in any form whatsoever. If you have received this
email in error please email the sender by replying to this message.
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
