This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
public:microsoft_sql_database [2019/08/21 15:28] ronnie.chan [Backup Modes] |
public:microsoft_sql_database [2019/08/21 15:30] ronnie.chan [Truncating Transaction Log] |
||
---|---|---|---|
Line 73: | Line 73: | ||
- 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 271: | Line 268: | ||
{{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 334: | Line 330: | ||
{{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 441: | Line 435: | ||
- 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> | + | |
---- | ---- |