Differences

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

--- public:microsoft_sql_database [2019/08/19 15:08]
ronnie.chan [VSS Backup Mode]
+++ public:microsoft_sql_database [2019/08/19 15:11]
ronnie.chan
@@ Line 292: / Line 292: @@
   - The Restore Raw File option is for advanced MS SQL Server administrator and should only be used if you have in-depth knowledge and understanding of your MS SQL Server, otherwise, it is not recommended to use this option as there are additional MS SQL techniques required to perform the manual restore.
-===== Limitation =====
+----
+===== Limitations =====
 ==== Standalone Environment Only ====
@@ Line 318: / Line 320: @@
   - 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.
+----
+===== Backup Modes =====
+You can choose from one of the two backup modes when creating a backup set for MS SQL server. The information below provides you with more details on each backup mode.
+<code>
+NOTE
+For MS SQL server backup sets which are upgraded from v6, the default backup mode will be ODBC.
+</code>
+==== VSS Mode ====
+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.
+{{public:ahsay_wiki_module_microsoft_sql_requirement_8.png?800}}
 ===== Documentation =====