Restart Firebird Baze - ODALJENO

Dbase, sql, paradox in vse drugo kar se tiče baz.
Odgovori
Simpatizer
Prispevkov: 143
Pridružen: 04.11.2002 09:49:08

Restart Firebird Baze - ODALJENO

Odgovor Napisal/-a Simpatizer » 10.03.2010 16:17:40

Ali je mogoče izvesti stop / start / restart Firebird baze iz oddaljene lokacije?
Lahko sicer dotopam do Service oddaljeno, v tem primeru lahko kot administrator ubijem vse servise in ne samo Firebird.
Hvala!

Fortuna
Prispevkov: 1097
Pridružen: 26.06.2004 09:59:52

Re: Restart Firebird Baze - ODALJENO

Odgovor Napisal/-a Fortuna » 18.10.2010 17:44:43

seveda gre v vseh operacijskih sistemih.
Povej na čem ti laufa firebird.

Načinov je več. Eden od načinov je nadzor na računlnikom TeamViewe ali kaj podbnega.

Preko Putty bi tudi šlo.
vnc itd....

TonyCaker
Prispevkov: 312
Pridružen: 27.09.2003 18:33:35

Re: Restart Firebird Baze - ODALJENO

Odgovor Napisal/-a TonyCaker » 22.10.2010 09:09:40

Nisi povedal, zakaj potrebuješ restart servisa. Za vzdrževalna dela na bazi pride v poštev tudi "shutdown":
Database Shutdown

When a database has been shut down, only SYSDBA and the database owner are able to connect to the database in order to perform administrative tasks.
Options

-at[tach] <seconds>

Used with the -shut option. Waits <seconds> seconds for all current connections to end. If after <seconds> seconds there are still connections open, the shutdown will be cancelled and return an error.

-f[orce] <seconds>

Used with the -shut option. Waits <seconds> seconds for all connections and transactions to end. After this time, all connections and transactions are cancelled and the database is shut down. Use with caution.

-o[nline]

If a -shut operation is pending, it is cancelled. Otherwise, takes a database back online

-sh[ut]

Shut down database. Must be used together with -attach, -force or -tran

-shut {normal | multi |
single | full}

-online {normal | multi |
single | full}



Firebird 2.0 and later: New shutdown modes:

NORMAL: Database is active and online
MULTI: Only connection from SYSDBA and the Database Owner will be allowed (compatible mode with Firebird 1.0/1.5)
SINGLE: Only one SYSDBA or Database Owner connection will be allowed
FULL: Exclusive shutdown: Database is completely offline, no connections will be allowed (it is now possible to access the database file safely on a file basis, e.g. for backups)

Use -shut to "go down" the scale of shutting down and -online to "go up" that scale.

-tr[an] <seconds>

Used with the -shut option. Waits <seconds> seconds for all running transactions to end. If after <seconds> seconds there are still running transactions, the shutdown will be cancelled.
Seveda se ga da narediti tudi remote.

LP

Fortuna
Prispevkov: 1097
Pridružen: 26.06.2004 09:59:52

Re: Restart Firebird Baze - ODALJENO

Odgovor Napisal/-a Fortuna » 22.10.2010 18:21:18


Odgovori