07 and backups - do not trust backupexec

CLIFFORD ILKAY clifford_ilkay at dinamis.com
Sun Jan 17 14:46:12 EST 2010


On 01/17/2010 02:28 PM, Joe Maus wrote:
> Hi,
>
>> -----Original Message-----
>> From: omnisdev-en-bounces at lists.omnis-dev.com [mailto:omnisdev-en-
>> bounces at lists.omnis-dev.com] On Behalf Of Doug Easterbrook
>> Sent: Sunday, January 17, 2010 10:44 AM
>> To: omnisdev-en at lists.omnis-dev.com
>> Subject: Re: 07 and backups - do not trust backupexec
>>
>> hi Wendy, and the world.
>>
>> I'll try to be plain and simple with this.
>>
>> NO BACKUP TOOL IN THE WORLD SHOULD BE TRUSTED TO BACKUP A LIVE
>> DATABASE.
>>
>> there... its off my chest.
>>
>> Why?   If any database:
>> - is in use, be it omnis .df1, oracle, mysql, postgres (doesn't matter)
>> AND
>> - it being used by the user AND
>> - any backup tool backs it up while in use (even if it has the ability
>> to do open files)
>>
>> then your backup is hopelessly corrupt.   It will either be:
>> a) physically corrupt OR
>> b) logically corrupt OR
>> c) both
>>
>> and definitely USELESS.
>
> I must take exception to this blanket statement having recovered multiple
> instances of Sybase and Oracle that were backed up "hot" using vendor
> supplied tools.
[snip]

I didn't interpret Doug's statement to mean that "vendor"-supplied tools 
wouldn't work. I interpreted it to mean that third-party backup programs 
wouldn't work for backing up databases. I inferred that from his 
explanation of how he backs up PG databases, which is how we've been 
backing them up for years. pg_dump is like your vendor-supplied Oracle 
of Sybase tool for doing hot backups.
-- 
Regards,

Clifford Ilkay
Dinamis
1419-3266 Yonge St.
Toronto, ON
Canada  M4N 3P6

<http://dinamis.com>
+1 416-410-3326



More information about the omnisdev-en mailing list