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 Next revision Both sides next revision | ||
|
public:microsoft_sql_database [2019/08/19 15:26] ronnie.chan |
public:microsoft_sql_database [2019/08/19 15:33] ronnie.chan [VSS Mode] |
||
|---|---|---|---|
| Line 4: | Line 4: | ||
| {{public:ahsay_wiki_microsoft_sql_database_backup_set.png?640}} | {{public:ahsay_wiki_microsoft_sql_database_backup_set.png?640}} | ||
| + | |||
| + | ---- | ||
| ===== System Architecture ===== | ===== System Architecture ===== | ||
| Line 164: | Line 166: | ||
| To prevent this from occurring, you can modify the recovery model of database selected for backup to Simple. | To prevent this from occurring, you can modify the recovery model of database selected for backup to Simple. | ||
| - | Alternatively, to truncate the transaction log files, you can perform a transaction log backup manually, or create an additional MS SQL database backup set in ODBC backup mode to perform a transaction log backup. | + | Alternatively, to [[#truncating_transaction_log|truncate the transaction log files]], you can perform a transaction log backup manually, or create an additional MS SQL database backup set in ODBC backup mode to perform a transaction log backup. |
| </WRAP> | </WRAP> | ||
| Line 265: | Line 267: | ||
| ^ msdb | Restore the msdb database if the master database has been rebuilt. | | ^ msdb | Restore the msdb database if the master database has been rebuilt. | | ||
| ^ distribution | For restore strategies of distribution database, please refer to the following online document from Microsoft for more details: [[http://msdn.microsoft.com/enus/library/ms152560.aspx]] | | ^ distribution | For restore strategies of distribution database, please refer to the following online document from Microsoft for more details: [[http://msdn.microsoft.com/enus/library/ms152560.aspx]] | | ||
| + | |||
| + | ---- | ||
| ===== Best Practice and Recommendation ===== | ===== Best Practice and Recommendation ===== | ||
| Line 321: | Line 325: | ||
| <WRAP indent> | <WRAP indent> | ||
| + | |||
| + | === Process === | ||
| + | |||
| + | {{public:ahsay_wiki_module_microsoft_sql_requirement_11.png?640}} | ||
| + | |||
| === Temporary Folder Requirement === | === Temporary Folder Requirement === | ||
| <WRAP indent> | <WRAP indent> | ||
| Line 368: | Line 377: | ||
| </WRAP> | </WRAP> | ||
| - | For MS SQL Server setups where you cannot modify the recovery model of the database, please refer to here for details on how to truncate transaction log (e.g. perform a transaction log backup manually). | + | For MS SQL Server setups where you cannot modify the recovery model of the database, please refer to [[#truncating_transaction_log|here]] for details on how to truncate transaction log (e.g. perform a transaction log backup manually). |
| </WRAP> | </WRAP> | ||
| Line 377: | Line 386: | ||
| <WRAP indent> | <WRAP indent> | ||
| + | |||
| + | === Process === | ||
| + | |||
| + | {{public:ahsay_wiki_module_microsoft_sql_requirement_12.png?640}} | ||
| + | |||
| === Temporary Folder Requirement === | === Temporary Folder Requirement === | ||
public/microsoft_sql_database.txt · Last modified: 2022/11/28 11:06 by kirk.lim