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/21 15:30] ronnie.chan [ODBC Backup Mode] |
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 435: | 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> | + | |
---- | ---- |