Good backup strategy for InterBase (and other DBMS)
This article has not been rated yet. After reading, feel free to leave comments and rate it.
I administer an InterBase server which is accessed by a few offices from around the globe. The server runs on a Windows 2000 Server box and we use Retrospect in our company to do a file backup.
db_2004_08_01.zip db_2004_08_02.zip db_2004_08_03.zip db_2004_08_04.zip
While the GDB (database image file) is about 300 or 400 MB in size, and the *.gbak backup file is of similar dimension, the ZIP files measure only 30 MB.
Every now and then I go in there, burn those ZIP files to a CDROM and delete them then.
This strategy allows me to go back to any database version as it was during the past couple of years. And of course, since the backups are done with gbak, they will always be clean. I've had the pleasure to do a few restores and it works fine.