DelphiFAQ Home Search:

Good backup strategy for InterBase (and other DBMS)

 

commentsThis 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.

This means that the *.gdb file gets backed up probably every day. As we recently learned from an oracle server crash, this is not enough. In the case of Oracle, the backed up database files could not be used because the Oracle server was running while the files were being backed up and the db could not be restored.

(Luckily I'm not responsible for the Oracle db)

For the InterBase database, I set up a windows scheduled task to run a perl script every evening to do a backup using gbak. Then the perl script runs zip to archive the *.gbak file.
The ZIP gets every day a unique file name including the full date so that the backup directory has files like this:

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.


Content-type: text/html

Comments:

2008-07-13, 06:09:07
anonymous from Pakistan  
i want

 

 

NEW: Optional: Register   Login
Email address (not necessary):

Rate as
Hide my email when showing my comment.
Please notify me once a day about new comments on this topic.
Please provide a valid email address if you select this option, or post under a registered account.
 

Show city and country
Show country only
Hide my location
You can mark text as 'quoted' by putting [quote] .. [/quote] around it.
Please type in the code:

Please do not post inappropriate pictures. Inappropriate pictures include pictures of minors and nudity.
The owner of this web site reserves the right to delete such material.

photo Add a picture: