Subject | Re: [ib-support] Connecting while Restore |
---|---|
Author | Jason Chapman (JAC2) |
Post date | 2002-10-25T13:05:20Z |
We rename the GDB file, so in the backup restore cycle.
1) Change name of gdb
2) backup (guarentees no-one logging in)
3) restore to another filename
4) rename restore to live gdb name.
Jason Chapman
JAC2 Consultancy
Training - Development - Consultancy
Delphi, InterBase, Firebird, OOAD, Development lifecycle assistance,
Troubleshooting projects, QA.....
www: When I get round to it....
Mob: (+44) 07966 211 959 (preferred)
Tel: (+44) 01928 751088
""Dimitry Sibiryakov"" <SD@...> wrote in message
news:3DB93357.29576.B6747C@localhost...
1) Change name of gdb
2) backup (guarentees no-one logging in)
3) restore to another filename
4) rename restore to live gdb name.
Jason Chapman
JAC2 Consultancy
Training - Development - Consultancy
Delphi, InterBase, Firebird, OOAD, Development lifecycle assistance,
Troubleshooting projects, QA.....
www: When I get round to it....
Mob: (+44) 07966 211 959 (preferred)
Tel: (+44) 01928 751088
""Dimitry Sibiryakov"" <SD@...> wrote in message
news:3DB93357.29576.B6747C@localhost...
> On 25 Oct 2002 at 8:11, Robbi wrote:
>
> >what's the best way to prevent users from trying to connect while the
> >database gets restored?
>
> Keep the password of SYSDBA (and, probably, database owner) in
> secret. Connecting of other users is prevented by engine (AFAIK).
>
> SY, Dimitry Sibiryakov.
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>