public:module:microsoft_sql_database:best_practice
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
public:module:microsoft_sql_database:best_practice [2019/09/12 15:21] ronnie.chan created |
public:module:microsoft_sql_database:best_practice [2019/09/19 17:55] (current) ronnie.chan |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== Best Practice and Recommendation ====== | + | ====== Best Practices and Recommendations ====== |
| ---- | ---- | ||
| + | |||
| + | {{INLINETOC}} \\ | ||
| ===== Considerations for System Databases Backup and Restore ===== | ===== Considerations for System Databases Backup and Restore ===== | ||
| + | ---- | ||
| Refer to the following tables for considerations for backup and restoration of system databases. | Refer to the following tables for considerations for backup and restoration of system databases. | ||
| Line 9: | Line 11: | ||
| ==== Backup ==== | ==== Backup ==== | ||
| + | ---- | ||
| SQL server maintains a set of system level database which are essential for the operation of the server instance. | SQL server maintains a set of system level database which are essential for the operation of the server instance. | ||
| Several of the system databases must be backed up after every significant update, they include: | Several of the system databases must be backed up after every significant update, they include: | ||
| Line 26: | Line 29: | ||
| ==== Restore ==== | ==== Restore ==== | ||
| + | ---- | ||
| ^ Heading 1 ^ Heading 2 ^ | ^ Heading 1 ^ Heading 2 ^ | ||
| ^ master | To restore any database, the instance of SQL server must be running. Startup of an instance of SQL server requires that the master database is accessible and at least partly usable. \\ \\ Restore or rebuild the master database completely if master becomes unusable. | | ^ master | To restore any database, the instance of SQL server must be running. Startup of an instance of SQL server requires that the master database is accessible and at least partly usable. \\ \\ Restore or rebuild the master database completely if master becomes unusable. | | ||
| Line 31: | Line 35: | ||
| ^ 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]] | | ||
| + | </WRAP> | ||
| - | ---- | + | \\ |
| ===== Best Practice and Recommendation ===== | ===== Best Practice and Recommendation ===== | ||
| + | ---- | ||
| The following are some best practice and recommendation we strongly recommend you to follow before you start any MS SQL Server backup and restore. | The following are some best practice and recommendation we strongly recommend you to follow before you start any MS SQL Server backup and restore. | ||
| - For VSS backup mode, it is suggested to set the backup schedule to a time when system activity is low to achieve the best possible performance. \\ \\ | - For VSS backup mode, it is suggested to set the backup schedule to a time when system activity is low to achieve the best possible performance. \\ \\ | ||
public/module/microsoft_sql_database/best_practice.1568272911.txt.gz · Last modified: 2019/09/12 15:21 by ronnie.chan
Page Tools
