DB Maintenance: Making a Backup File (.GBK)
(Related procedures: Backup and Restore, Restore only.)

This article applies to Bundle-Track versions 3.6 and later.

IMPORTANT: If you are doing this as part of a Backup and Restore cycle, use that procedure instead, OR YOU MAY LOSE CURRENT DATA.

Process
Perform the following steps on your Production database.

1. Disconnect all Bundle-Track users.
   • Direct all users to exit Bundle-Track and stay out until you advise them that they may return.
      
2. Open IBConsole and Locate the Database
   • If you don't know how, click here to learn, and then return.
      
3. Put the Database into Single-User Mode.
   
   1. Connect to the database.
      • If you don't know how, click here to learn, and then return.
        
   2. Right-click on the database name, then select 'Maintenance' and 'Shutdown'.
   3. Set the 'Shutdown' option to 'Force shutdown after timeout.'
   4. Set the 'Shutdown Timeout' value to 0.
   5. Click OK and await shutdown confirmation.
       
4. Create a Backup File.
   
   1. From the Database menu, select Maintenance >> Backup / Restore >> Backup.
      • This opens the 'Database Backup' screen.
   2. Use the Database area's Alias dropdown to select the database you want to process.
   3. Set the Backup fields:
      • Server:
        • (This should already be set.)
      • Alias:
        • If the desired Alias is not listed in the dropdown, type a new Alias yourself (for example, 'bt30600prod.gbk'), and be sure to use .gbk at the end of the filename.
      • Filename:
        • Specify the full path for the Backup file you want to create.
        • You can avoid typos by opening the destination folder in Windows Explorer and copying the path from the address bar, but then remember to add the filename at the end.
        • The filename must end with the .gbk file extension.
   4. Set the 'Garbage Collection' option (on the right) to False.
   5. Click OK to start the Backup.
   6. Await confirmation that the process completed successfully.
      • It may take a few minutes.
      • If the backup is successful, the last lines in the log will read
        gbak: closing file, committing, and finishing. <number> bytes written
 
Service ended at <date and time finished>
      • If you receive any error messages, perform the Backup process again. (From the Database menu, select Maintenance >> Backup / Restore >> Backup.)
      • If you receive a second error message, contact Bundle-Track Support (info at the top-right of this page).
         
5. Restart the Database
   1. Confirm that the database is currently connected ().
      • If it isn't, double-click the database icon.
   2. Right-click on the database name, then select 'Maintenance' and 'Database Restart'.
       
      
6. Notify the Users that they may return to Bundle-Track.   

Were you working on something? Return links: Sending us your database, Upgrading from version 3.6 and Higher.

We welcome your comments at support@bundle-track.com.

If you would like our live assistance, you may hire us at our professional services rate.