"Fernando Dias" <fernandodias.removthis@easygate.com.pt> wrote on Wed, 22 Mar 2006 15:55:41 -0000

>The backup runs inside a transaction, so other users can read the database
>but can't change it until the backup is completed. It is a fast process, so
>if you backup to HD, it will block writes only for short time.
>

Hi

You can do exactly the same in v3.30.

MyDB.StartTransaction;
try
   // do backup here - I use VCLZip
finally
   MyDB.RollBack;
end;

I've been doing this for a couple of years and had many restores (as I use the technique for shipping databases around the place) and never a corrupt database.

Cheers
Jeff

--
Jeff Cook
Aspect Systems Ltd
Phone: +64-9-424 5388
Skype: jeffcooknz
www.aspect.co.nz

Hi,

> You can do exactly the same in v3.30.

Yes, but with V4 it's automatic - you don't need to explicitly
"StartTransaction".
Also, V4 uses it's own backup file format, with (optional) compression.

Best Regards

--
Fernando Dias

"Fernando Dias" <fernandodias.removthis@easygate.com.pt> wrote on Thu, 23 Mar 2006 15:38:07 -0000

>Hi,
>
>> You can do exactly the same in v3.30.
>
>Yes, but with V4 it's automatic - you don't need to explicitly
>"StartTransaction".
>Also, V4 uses it's own backup file format, with (optional) compression.
>
>Best Regards
>
>--
>Fernando Dias
>
>
>
Fernando


I'll take your word for it.   The original poster, Al Vas,  is using v3.30 - which was the point of my post

Cheers

Jeff Cook



--
Jeff Cook
Aspect Systems Ltd
Phone: +64-9-424 5388
Skype: jeffcooknz
www.aspect.co.nz

Jeff,

> I'll take your word for it.
Belive me! It's true !

Best Regards

--
Fernando Dias

Thanks All,

And thanks Jeff, we'll be using this for sure.  Just one question.  Our app
might have 10 users at once, if someone is currently editing a record (we
use pessimistic locking), would this present an issue?

Thanks

Alex


"Jeff Cook" <jeffc@aspect.co.nz> wrote in message
news:BCC83C86-43F9-41F6-B88F-0345B6FBE13F@news.elevatesoft.com...
> "Fernando Dias" <fernandodias.removthis@easygate.com.pt> wrote on Thu, 23
> Mar 2006 15:38:07 -0000
>
>>Hi,
>>
>>> You can do exactly the same in v3.30.
>>
>>Yes, but with V4 it's automatic - you don't need to explicitly
>>"StartTransaction".
>>Also, V4 uses it's own backup file format, with (optional) compression.
>>
>>Best Regards
>>
>>--
>>Fernando Dias
>>
>>
>>
> Fernando
>
>
> I'll take your word for it. The original poster, Al Vas, is using v3.30 -
> which was the point of my post
>
> Cheers
>
> Jeff Cook
>
>
>
> --
> Jeff Cook
> Aspect Systems Ltd
> Phone: +64-9-424 5388
> Skype: jeffcooknz
> www.aspect.co.nz
>
>
>
>

Alex,

<< And thanks Jeff, we'll be using this for sure.  Just one question.  Our
app might have 10 users at once, if someone is currently editing a record
(we use pessimistic locking), would this present an issue? >>

Nope, record locks are fine - the only thing that matters is a Post or
another transaction.  Both of these things will be blocked until the backup
is completed if the backup is enclosed within a StartTransaction..Commit
block.

--
Tim Young
Elevate Software
www.elevatesoft.com