Server Backup

Backup Microsoft SQL Server

Backup MS SQL Server database files without interfering the running MS SQL Server services, using IDrive Vault.

To backup your MS SQL Server,

  1. Log into IDrive Vault desktop application.
  2. Click IDrive Vault on the Server Backup section.

  3. On the expanded section, mouse over over MS SQL Server and click 'Schedule Now'.
    The SQL Backup Status window appears.
  4. Click 'Add Backup Set'. The SQL login window appears.

  5. IDrive Vault provides two modes of MS SQL Server authentication.

  6. Click ‘Connect’. The Scheduler window appears.
  7. Select the databases to be backed up and select the time and days for a scheduled backup.
    For an immediate backup, check the box against 'Start the backup immediately'.
  8. Click 'Update'.

The next time you log in, the created backup set will appear in the SQL Backup Status window. If the backup set name is 'SQL_BackupSet_yyyymmddhhmmss, right-click on the backup set name. The context menu will open. Click ‘Backup’ to start an interactive backup. Click ‘Restore’ to restore the particular backup set. Click ‘Delete’ to delete the backup set.

Note: Selected databases from the SQL Server would get copied in the local IDrive Vault cache (C:\IDriveVaultCache). From there, the databases would be backed up to the Vault device using rsync.