Limitations

Standalone Environment Only

AhsayOBM does not support backup of MS SQL server in cluster environment, only standalone environment is supported.

VSS Backup Mode

  • Only support backup of database on local drive. Database on network drive is not supported. For backup of database on a network drive, it is recommended to use ODBC backup mode instead.

  • VSS backup mode does not support transaction log backup, therefore, transaction log backup will have to be done manually. Or you can choose ODBC backup mode for transaction log backup.

  • For AhsayOBM versions before 9.5.0.0, in order to truncate transaction logs, you have to perform a manual log truncation, which could be time consuming.

File System For Database Snapshot

You cannot create database snapshots on FAT32 file system or RAW partitions. The sparse files used by database snapshots are provided by the NTFS file system.

SQL Server Version

Automated Restore Option

If you have chosen the automated restoration to the Original SQL server or Alternate SQL server of your selection, the restoration can only be done in a SQL server version that is the same as the one used for performing the backup.

Manual Raw File Restore Option

If you have chosen to restore the raw file, the raw database file(s) can be manually restored to the same or newer SQL server version that you used to perform the backup.

Restoration to Other SQL Server

  • If you would like to restore database to an alternate SQL server, you can only choose to restore one database to restore at a time.

  • If you would like to restore database to an alternate SQL server, make sure you choose to restore raw file by enabling the checkbox Restore raw file.

Remote Machine Backup

MS SQL server databases backup running on a remote machine is not supported. Ensure that the latest version of AhsayOBM is installed directly on the MS SQL server.