Subject Re: [ib-support] Backup and restore of a database
Author Bill Katelis
Am I missing something here ...

If you issue a
#gfix -shut -force 0 <db>

that would prevent anyone from connecting to the db (as long as they are
not sysdba).

Anthony Ison wrote:

>>You shouldn't be renaming database files in their normal location while
>>
>>
>the
>
>
>>server is running, anyway. Of course you can expect corruption if you try
>>to do any filesystem-level things to the database whilst users are
>>connected, or trying to connect. You can't fix a puncture on a moving
>>
>>
>vehicle!
>
>Is it possible to disconnect a single database without taking down the whole
>server? I need to run 2 applications and allow access to one while
>maintaining the other.... Also, is renaming a database the same as copying
>the file? That is, can renaming the file corrupt the database as well? I
>seem to be able to copy a database while connected and copy it back over
>itself.... Not recommended that you try this at home.... However, if you
>try to rename the file, it says it is in use... Is it safe to rename an
>interbase database? If it works no one was connected...?
>
>
>
>>You shouldn't even try to perform metadata updates whilst you don't have
>>exclusive access to the database...
>>
>>
>
>Is it possible to enforce this without shutting down the server? Also, what
>can I check to ensure my database isn't currently in use?
>
>
>
>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/
>
>
>