public:module:microsoft_sql_database:limitation
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
public:module:microsoft_sql_database:limitation [2019/09/12 15:22] ronnie.chan |
public:module:microsoft_sql_database:limitation [2019/09/19 17:57] (current) ronnie.chan |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== Limitation ===== | + | ====== Limitations ===== |
| ---- | ---- | ||
| + | {{INLINETOC}} \\ | ||
| ===== Standalone Environment Only ===== | ===== Standalone Environment Only ===== | ||
| - | AhsayOBM does not support backup of MS SQL server in cluster environment, only standalone environment is supported. | + | ---- |
| + | CloudBacko Pro does not support backup of MS SQL server in cluster environment, only standalone environment is supported. | ||
| ===== VSS Backup Mode ===== | ===== VSS Backup Mode ===== | ||
| + | ---- | ||
| - Only support backup of database on local drive. Database on network drive is not supported. \\ \\ | - 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. \\ \\ | - 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. | - In order to truncate transaction logs, you have to perform a manual log truncation, which could be time consuming. | ||
| - | ===== File System for Database Snapshot ===== | + | ===== 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. | 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 ===== | ===== SQL Server Version ===== | ||
| + | ---- | ||
| <WRAP indent> | <WRAP indent> | ||
| - | ==== 1. Automated Restore Option ===== | + | ==== 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. | 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. | ||
| - | ==== 2. Manual Raw-file Restore Option ==== | + | ==== 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. | 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. | ||
| </WRAP> | </WRAP> | ||
| ===== Restoration to Other SQL Server ===== | ===== 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, 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. | - 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.1568272931.txt.gz · Last modified: 2019/09/12 15:22 by ronnie.chan
Page Tools
