Differences

This shows you the differences between two versions of the page.

--- public:module:microsoft_sql_database:requirements [2021/04/19 10:38]
ronnie.chan
+++ public:module:microsoft_sql_database:requirements [2021/04/19 11:35]
ronnie.chan
@@ Line 1: / Line 1: @@
 ====== Requirements ======
-----
 You are strongly recommended to configure or check all the requirements below before you proceed with the MS SQL server backup and restoration.
@@ Line 24: / Line 24: @@
 ===== MS SQL Server Registry =====
-----
 Make sure the MS SQL entry is present in the registry key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL".
 To access this path, type “regedit” in the command prompt to launch the Registry Editor.
@@ Line 34: / Line 34: @@
 </WRAP>
+===== SQL Server Services =====
-CloudBacko Pro supports 2 backup modes when creating a backup set for MS SQL server, VSS mode and ODBC mode.
+Ensure that the following SQL Server Services have been enabled in the Windows Services menu. Launch Services in Windows by clicking Start then typing “Services” in the search box. All MS SQL server related services should be started by default. If in case it is not, turn it on by right clicking the item then selecting Start.
-===== VSS Backup Mode =====
+{{public:module:microsoft_sql_database:cloudbacko_module_sql_003.png?800}}
-----
-The VSS-based backup utilizing the Microsoft SQL Server VSS Writer to obtain a consistent snapshot of the MS SQL databases, no spooling / staging of database file(s) is required during the backup process.
-<WRAP indent>
-=== CloudBacko Pro Installation ===
+===== Transport Layer Security(TLS) =====
-----
-Make sure the latest version of CloudBacko Pro has been installed on the MS SQL server.
-=== SQL Add-On Module ===
+For MS SQL Server 2005, 2008, 2012, and 2014 VSS and ODBC backup modes, TLS version 1.0 must be enabled as only TLS version 1.0 is supported.
-----
-Make sure the Microsoft SQL Server backup module has been purchased for your CloudBacko Pro license.
-=== Continuous Backup Module ===
+To check if TLS 1.0 is enabled on the MS SQL machine, launch the registry editor and locate the following path:
-----
-The continuous backup add-on module is required if you would like to enable the continuous backup feature.
+“HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.0\Client”
-=== Java Heap Size ===
+The value of registry key should be “1” to indicate that TLS 1.0 is enabled.
-----
-The default Java heap size setting on CloudBacko Pro is 2048MB. For MS SQL Server backup it is highly recommended to [[https://forum.cloudbacko.com/viewtopic.php?f=40&t=1628&p=7639&hilit=java+heap#p7639|increase the Java heap size setting]] to be at least 4096MB to improve backup and restore performance. The actual heap size is dependent on amount of free memory available on your MS SQL server.
+| {{public:module:microsoft_sql_database:image1019.png?800}} |
+Meanwhile, for MS SQL Server 2016, 2017 and 2019 VSS and ODBC backup modes, TLS version 1.2 must be enabled as only TLS version 1.2 is supported.
+To check if TLS 1.2 is enabled on the MS SQL machine, launch the registry editor and locate the following path:
+“HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2\Client”
+The value of registry key should be “1” to indicate that TLS 1.2 is enabled.
+| {{public:module:microsoft_sql_database:image1023.png?800}} |
+===== Upgrade VMware Tools Requirement =====
+To avoid unexpected java crash, if the Windows machine is a guest VM hosted on a VMware Host then it is highly recommended that the VMware tools version installed on the guest VM must be 10.0.5 or above. Below is the warning message that will be displayed if the version of the VMware Tools is less than 10.0.5.
+| {{public:module:microsoft_sql_database:image1025.png?800}} |
+===== VSS Backup Mode =====
+The VSS-based backup utilizing the Microsoft SQL Server VSS Writer to obtain a consistent snapshot of the MS SQL databases, no spooling / staging of database file(s) is required during the backup process.
+<WRAP indent>
 === User Account Privileges ===
-----
 Make sure the operating system account that performs the backup and restore has sufficient permission to access both SQL server and VSS.
 === Temporary Directory Folder ===
-----
   - The temporary directory folder is used by CloudBacko Pro for storing backup set index files and incremental/differential delta files. To ensure optimal backup/restoration performance, it is recommended that the temporary directory folder to be set to a local drive. The temporary folder should not be located on Windows system partition or the database partition to minimize any potential performance impact on Windows or database.
   - It is recommended that the temporary directory folder should have at least free disk space of 50% of the total database size because the default Delta ratio is 50%. The actual free disk space required depends on various factors including the size of the database, number of backup destinations, backup frequency, in-file delta settings etc.
@@ Line 69: / Line 85: @@
 === SQL Server VSS Writer ===
-----
 Make sure the SqlServerWriter has been installed and running on the SQL server, and the writer state is Stable. This can be verified by running the “vssadmin list writers” command in the Windows Command Prompt.
@@ Line 161: / Line 177: @@
 {{public:module:microsoft_sql_database:cloudbacko_module_sql_002.png?800}}
-. SQL Server Services
-{{public:module:microsoft_sql_database:cloudbacko_module_sql_003.png?800}}
 . Volume Shadow Copy
@@ Line 170: / Line 183: @@
 {{public:module:microsoft_sql_database:cloudbacko_module_sql_004.png?800}}
 </WRAP>
 === MS SQL Recovery Model ===
@@ Line 181: / Line 193: @@
 </WRAP>
+CloudBacko Pro supports 2 backup modes when creating a backup set for MS SQL server, VSS mode and ODBC mode.
+===== VSS Backup Mode =====
+----
+The VSS-based backup utilizing the Microsoft SQL Server VSS Writer to obtain a consistent snapshot of the MS SQL databases, no spooling / staging of database file(s) is required during the backup process.
+<WRAP indent>
+=== CloudBacko Pro Installation ===
+----
+Make sure the latest version of CloudBacko Pro has been installed on the MS SQL server.
+=== SQL Add-On Module ===
+----
+Make sure the Microsoft SQL Server backup module has been purchased for your CloudBacko Pro license.
+=== Continuous Backup Module ===
+----
+The continuous backup add-on module is required if you would like to enable the continuous backup feature.
+=== Java Heap Size ===
+----
+The default Java heap size setting on CloudBacko Pro is 2048MB. For MS SQL Server backup it is highly recommended to [[https://forum.cloudbacko.com/viewtopic.php?f=40&t=1628&p=7639&hilit=java+heap#p7639|increase the Java heap size setting]] to be at least 4096MB to improve backup and restore performance. The actual heap size is dependent on amount of free memory available on your MS SQL server.
 ==== ODBC Backup Mode ====

User Tools

Site Tools

Differences

Page Tools