Sidebar
public:module:microsoft_sql_database:limitation
Limitations
Standalone Environment Only
CloudBacko Pro 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.
- 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.
- 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.
public/module/microsoft_sql_database/limitation.txt · Last modified: 2019/09/19 17:57 by ronnie.chan
