Subject | Re: [ib-support] Re: maintenance strategie |
---|---|
Author | Jason Chapman (JAC2) |
Post date | 2002-02-01T10:22:46Z |
Fred, just a couple of comments -
little sledge hammery (you need a file with the one line ommited).
want users continuing to use the db.
> We have an "automated" backup and restore for our sites. Here's what we doa
> (Server = NT4.0 or W2000), via .cmd files and the windows scehduler (AT
> command):
> - make sure there are no connections to the database by stopping IB, copy
> service file that has no gds entry (to stop anyone from logging into IBWouldn't a rename be just as good, seems that doing a services file seems a
> until we're finished), and restart IB
little sledge hammery (you need a file with the one line ommited).
> - Backup the database using gbak to a backup directory and check forerrors
> - If errors, log the event to a log file, stop IB, copy the old servicesSurely if the backup fails, you must suspect the source db, do you really
> file back in place, restart IB and quit
want users continuing to use the db.
> - If no errors, stop IB, then, using the command "MOVE", move the active
> database directory to a "save" directory.