The following list includes compatibility scenarios:
- If a major version of the SQL Server instance on the production host is newer than the instance of the mount host, recovery fails for all databases belonging to that instance. For example: SQL database from production SQL Server 2014 (version: 12.3.6108.1, having major version: 12, minor version: 3) is mounted with recovery on mount host with SQL Server 2012 (version: 11.1.3128.0 having major version: 11, minor version: 1), the recovery would fail.
- If the major version of the SQL Server instance on the production host is older than that of the mount host, recovery succeeds only if the recovery type is either RECOVERY or NORECOVERY. Recovery fails if the recovery type is STANDBY. Example: When mounting the SQL database from production SQL Server 2012 (version: 12.3.6108.1) on mount host with SQL Server 2014 (version: 14.0.1000.169), if the recovery type selected is Standby, recovery would fail. But if recovery is attempted with RECOVERY or NORECOVERY selected, it will be successful.
- If the major version of the SQL Server instance on the production host is the same as of the mount host, but the minor version is newer, recovery fails for all databases belonging to that instance.
- If the major version of the SQL Server instance on the production host is the same as the instance of the mount host, but the minor version is older, recovery succeeds only if the recovery type is either RECOVERY or NORECOVERY. Recovery fails if the recovery type is STANDBY.
- If the version of SQL Server instance on the mount host is newer than the instance of the production host, the database version is upgraded on recovery. However, in Dell RecoverPoint, the changes are discarded when the bookmark is dismounted.
- If the SQL database is upgraded to another version while mounting to another SQL Server instance, the above version compatibility rules for major and minor versions are performed on mounting the same SQL database to any other SQL server instances. Example: Suppose a SQL database from production instance with SQL Server 2012 instance (version: 11.1.3128.0) is mounted to another SQL Server 2017 instance (version: 14.0.1000.16), the SQL database version is upgraded. If the database is unmounted and mounted again on another SQL Server 2014(version:12.3.6108.1), the recovery fails.