We have an "automated" backup and restore for our sites. Here's what we do
(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 a
service file that has no gds entry (to stop anyone from logging into IB
until we're finished), and restart IB
- Backup the database using gbak to a backup directory and check for errors
- If errors, log the event to a log file, stop IB, copy the old services
file back in place, restart IB and quit
- If no errors, stop IB, then, using the command "MOVE", move the active
database directory to a "save" directory.
- Start IB
- Restore the backup to the active database directory
- If errors, stop IB, and delete the "restored" database files and "MOVE"
the save directory back to the active directory, copy the old services file
back to the original,restart IB, log the event, and quit
- If no errors, log the event, stop IB, copy the original services file back
into place, restart IB and we're finished


Regards,
Fred Wilson
SE, Bell & Howell
fred.wilson@... <mailto:fred.wilson@...>


-----Original Message-----
From: Aage Johansen [mailto:aagjohan@...]
Sent: Monday, January 28, 2002 2:05 PM
To: ib-support@yahoogroups.com
Subject: [ib-support] Re: maintenance strategie

>but I need to make those things as easy as possible for my customers.
>Any idea to automate this ?
>My db is not busy 24x7. The weekend is a good period to do this.

You can automate it. You can use the Windows scheduler (AT) to run batch
filles, or you can use a 3rd party program.
HOWEVER, I don't think I would ever let a restore automaticaly (unattended)
overwrite the current database. It just might happen that the backup has
errors. If the restore fails after overwriteing some of the database, your
users will not love you. You will have to be very careful.
Consider giving the users a written procedure for doing the backup/restore
including testing the restored db, and provide them with either complete
batch-files with gabk (backup, and restore), or one of the free backup
utilities (with parameters in place).
As long as your db does not use multiple files you can freely copy
databases around.


Regards,
Aage J.




Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=218512.1856015.3360178.1269402/D=egroupweb/S=17050077
09:HM/A=928902/R=0/*http://ad.doubleclick.net/clk;3788030;6800959;r%3fhttp:/
/www.verisign.com/cgi-bin/go.cgi?a=b229573240057000>

<http://us.adserver.yahoo.com/l?M=218512.1856015.3360178.1269402/D=egroupmai
l/S=1705007709:HM/A=928902/rand=112131340>

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .