public:microsoft_sql_database
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
public:microsoft_sql_database [2019/08/19 15:35] ronnie.chan |
public:microsoft_sql_database [2022/11/28 11:06] (current) kirk.lim Last modified: 2019/08/26 11:12 by ronnie.chan |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== Microsoft SQL Database Backup Set ===== | ====== Microsoft SQL Database Backup Set ===== | ||
| + | |||
| + | Last modified: 2019/08/26 (Note: Content written for AhsayCBS v7+v8, and may generally apply to latest product release) | ||
| AhsayOBM allows you to back up databases in your Microsoft SQL Server with the MS SQL Server Backup Module, which provides you with a set of tools to protect your MS SQL Server, whether in VSS backup mode or ODBC backup mode. | AhsayOBM allows you to back up databases in your Microsoft SQL Server with the MS SQL Server Backup Module, which provides you with a set of tools to protect your MS SQL Server, whether in VSS backup mode or ODBC backup mode. | ||
| Line 10: | Line 12: | ||
| Below is the system architecture diagram illustrating the major elements involved in the backup process among the MS SQL server, AhsayOBM and AhsayCBS. | Below is the system architecture diagram illustrating the major elements involved in the backup process among the MS SQL server, AhsayOBM and AhsayCBS. | ||
| - | {{public:ahsay_wiki_module_microsoft_sql_requirement_1.png?800}} | + | {{public:content_components_mssql.png?800}} |
| ---- | ---- | ||
| Line 16: | Line 18: | ||
| ===== Backup Modes ===== | ===== 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. | 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> | + | <WRAP info> |
| - | NOTE | + | |
| For MS SQL server backup sets which are upgraded from v6, the default backup mode will be ODBC. | For MS SQL server backup sets which are upgraded from v6, the default backup mode will be ODBC. | ||
| - | </code> | + | </WRAP> |
| ==== VSS Mode ==== | ==== VSS Mode ==== | ||
| Line 74: | Line 75: | ||
| - The current recovery model is displayed in the Recovery model list box. Modify the recovery model by selecting Simple from the model list. | - The current recovery model is displayed in the Recovery model list box. Modify the recovery model by selecting Simple from the model list. | ||
| - | <WRAP prewrap> | + | <WRAP important> |
| - | <code> | + | |
| - | IMPORTANT: | + | |
| Only modify the recovery model of a live database during low activities hour. It is also recommended to perform a full backup before changing the recovery model. | Only modify the recovery model of a live database during low activities hour. It is also recommended to perform a full backup before changing the recovery model. | ||
| - | </code> | ||
| </WRAP> | </WRAP> | ||
| Line 272: | Line 270: | ||
| {{public:ahsay_wiki_module_microsoft_sql_requirement_5.png?800}} | {{public:ahsay_wiki_module_microsoft_sql_requirement_5.png?800}} | ||
| - | <code> | + | <WRAP info> |
| - | NOTE | + | |
| Pay extra attention when you are checking configuration in Registry Editor. Any unauthorized changes could cause interruption to the Windows operation. | Pay extra attention when you are checking configuration in Registry Editor. Any unauthorized changes could cause interruption to the Windows operation. | ||
| - | </code> | + | </WRAP> |
| === MS SQL Recovery Model === | === MS SQL Recovery Model === | ||
| Line 335: | Line 332: | ||
| {{public:ahsay_wiki_module_microsoft_sql_requirement_8.png?800}} | {{public:ahsay_wiki_module_microsoft_sql_requirement_8.png?800}} | ||
| - | <WRAP prewrap> | + | <WRAP info> |
| - | <code> | + | |
| Note: Pay extra attention when you are checking configuration in Registry Editor. Any unauthorized changes could cause interruption to the Windows operation. | Note: Pay extra attention when you are checking configuration in Registry Editor. Any unauthorized changes could cause interruption to the Windows operation. | ||
| - | </code> | ||
| </WRAP> | </WRAP> | ||
| Line 442: | Line 437: | ||
| - Go to the Backup Options, then in the Backup set section, name the backup set and enter a description of the backup set if needed. \\ \\ Configure the Backup set to expire after a specified number of day or on a specified date. Set to 0 day if you do not want the backup set to expire \\ {{public:ahsay_wiki_module_microsoft_sql_requirement_19.png?640}} | - Go to the Backup Options, then in the Backup set section, name the backup set and enter a description of the backup set if needed. \\ \\ Configure the Backup set to expire after a specified number of day or on a specified date. Set to 0 day if you do not want the backup set to expire \\ {{public:ahsay_wiki_module_microsoft_sql_requirement_19.png?640}} | ||
| - Click OK to start the transaction log backup when you are done with all the necessary settings in the Back Up Database dialog box. \\ {{public:ahsay_wiki_module_microsoft_sql_requirement_20.png?640}} | - Click OK to start the transaction log backup when you are done with all the necessary settings in the Back Up Database dialog box. \\ {{public:ahsay_wiki_module_microsoft_sql_requirement_20.png?640}} | ||
| - | </WRAP> | + | |
| ---- | ---- | ||
public/microsoft_sql_database.1566200105.txt.gz · Last modified: 2019/08/19 15:35 by ronnie.chan