How to backup a remote database directly to the local machine.

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



IBConsole executes the backup command on the server and only seems to allow the backup file to be written to the same machine. To backup 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!

Average rating: