---In firebird-support@yahoogroups.com, <maciejlik@...> wrote :
...
Hope it helps,
Vlad
> Before making repair the database checked the database are logged 2 users SYSDBA (server and client). In this case,
> the command gfix not block access to the database - not disconnect the user SYSDBA client.
Read http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/gfix-dbstartstop.html#d0e30113
carefully and choose what you really need. For example, you may want to get of all users from db (including SYSDBA):
gfix -shut full -force 0
...then allow single attachment...
gfix -online
> the command gfix not block access to the database - not disconnect the user SYSDBA client.
...
> What command to use before taking any remedial action on the database Firebird to disconnect a user SYSDBA (client)?
Read http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/gfix-dbstartstop.html#d0e30113
carefully and choose what you really need. For example, you may want to get of all users from db (including SYSDBA):
gfix -shut full -force 0
...then allow single attachment...
gfix -online single
...to validate database...
gfix -v -full
...and finally bring database online for all users
gfix -online
Hope it helps,
Vlad
__._,_.___
Posted by: hvlad@users.sourceforge.net
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
Save time and get your email on the go with the Yahoo Mail app
Get the beautifully designed, lighting fast, and easy-to-use Yahoo Mail today. Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
.
__,_._,___
No comments:
Post a Comment