On Thu, 14 Apr 2011 09:54:09 +0200, Christian Manal
<moenoel AT informatik.uni-bremen DOT de> wrote:
> Am 14.04.2011 08:33, schrieb James Harper:
>> The "last modified" datestamp on MSSQL database files doesn't get
>> changed unless the actual file dimensions change (eg it 'grows') or
when
>> the file is closed. This means that an incremental backup won't
>> necessarily back up the database files unless they have changed.
>> Accurate won't catch this either as the metadata it uses will be
>> identical.
>>
>> Is there a way to force the backup of specific unchanged files during
an
>> incremental or differential backup? Eg:
>>
>> Option {
>> File = "C:/database/mydb.mdf"
>> Always Back Up = Yes
>> }
>>
>> Thanks
>>
>> James
>
> Hi,
>
> does the file change at all? If so, you can just adjust the metadata
> that Accurate uses to compare checksums. That is done in the fileset:
>
>
http://bacula.org/5.0.x-manuals/en/main/main/Configuring_Director.html#8553
>
>
> Regards,
> Christian Manal
>
Hello,
AFAIK, you should never backup MSSQL databases when they are running. If
you do so, the database will try to recover from a crash and you can loose
data pieces. Files do not reflect the status of the database.
You should back it up correctly, using a database agent (eg: Litespeed) or
SQL scripts to dump it then archive it.
If you do so, you will be able to backup transaction log too and will be
able to perform PIT restores.
You could start from the catalog backup job to adapt it to your needs.
For Mysql, there is one interesting way : flush tables with read lock +
LVM snapshot. Files are coherent, and backed up at the exact same time.
Perhaps you could use a similar way to backup database's files.
HTH.
Jerome Blion.
------------------------------------------------------------------------------
Benefiting from Server Virtualization: Beyond Initial Workload
Consolidation -- Increasing the use of server virtualization is a top
priority.Virtualization can reduce costs, simplify management, and improve
application availability and disaster protection. Learn more about boosting
the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
