Back Up a Remote Database Locally

Back Up a Remote Database Locally

Back Up a Remote Database Locally : Multi-thousand tips to make your life easier.

How to back up a remote database directly to the local machine.

My company had a server with a nearly full hard disk. I needed to back up the database but didn't have enough disk space to store both the database and the backup.

IBConsole executes the backup command on the server and seems to allow the backup file to be written only to the same machine. To back up to my local machine, I had to use GBAK in a command prompt, like so:

gbak -b -z ServerName:C:\DatabasePath\DatabaseName.gdb c:\MyLocalBackupPath\MyLocalBackupName.gbk -verbose -user sysdba -password masterkey

This did the trick.