Subject | RE: [IBO] Re: Connection string to FilePath? |
---|---|
Author | Alan McDonald |
Post date | 2004-10-08T23:05:23Z |
> My reason for asking this is in the context of making a feature in mythen do you customer a favour and install this service
> application for sites to backup and restore their FB datafile in as
> simple a manner as possible.
http://www.is.svitonline.com/ddking/
on their server when you install FB. Then visit them or train one person or
write up a clear procedure to do a once per annum restore.
> I want a solution to be friendly toas I say - this is purely up to the processor speed and gbak you can't
> users whose applications may be forced to close and to minimise the
> time they cannot reconnect to the datafile.
>
hasten it past these variables.
> So I thought a strategy to minimise the offline time would be to:as long as noone is updating while you backup - otherwise, rename before you
> 1. make a backup file (FileBK) of the datafile FileBD.
> 2. rename the datafile FileDB->FileOldDB_date
backup
> 3. rename the backup FileBK->FileDBthe connections have to be refused as soon as (*before*) the backup starts
> 4. do something with FileOldDB_data
>
> Perhaps the IBOAdmin code does this, I don't know. It seemed to me
> this would reduce the time the Datafile was unavailable to my
> application. During the backup apps could request a login but would
> be refused in a friendly manner as the datafile "knows" a backup is
> underway and a restore is coming. Only when a restore was planned
> would connections be refused.
><snip>
> To do the renaming I'd need access to the file in the FB DB folder.
Alan