Subject | Re: maintenance strategie |
---|---|
Author | Aage Johansen |
Post date | 2002-01-28T21:05:01Z |
>but I need to make those things as easy as possible for my customers.You can automate it. You can use the Windows scheduler (AT) to run batch
>Any idea to automate this ?
>My db is not busy 24x7. The weekend is a good period to do this.
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.