Backup

This section of the CSI SQL Xchange allows you to backup a CSI SQL database.

The top dropdown-list presents you with an overview of all CSI databases which are stored on the SQL server to which you are currently connected.

After selecting a database you wish to backup, indicate the folder where you wish to create the backup and modify the filename if you do not wish to use the default naming.

Note: The CSI SQL Xchange will propose an output location based on the folder of your previous backup appended with the name of the database you currently selected

• Overwrite file if exists: When the output file already exists it will be overwritten when this option is checked.

Note: Make sure you do not need the older backup file before overwriting it. 

• Shrink database: When this option is checked, the CSI SQL Xchange will compact the database on the server before taking a backup. When successful this will reduce both the actual database and the backup file.

• Clear database log: When this option is checked, the CSI SQL Xchange will clear the database log on the server before taking a backup. This implies that no backup of this log file will be taken.

When you have selected a database to backup, indicated the output file (and adjusted the backup options) click the Backup button.

Note: It is not possible to backup a database if SQL Xchange (tool/module) is not running on the machine running SQL server. That is, a remote backup is not possible.