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:00] ronnie.chan [Backup] |
public:microsoft_sql_database [2019/08/19 15:03] ronnie.chan [Best Practice and Recommendation] |
||
|---|---|---|---|
| Line 277: | Line 277: | ||
| ==== 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. | |
| - | | model | Restore the model database if: \\ * The master database has been rebuilt. \\ * The model database has been damaged, for example due to media failure. \\ * The model database has been modified, in this case, it is necessary to restore model from a backup when you rebuild master, because the Rebuild Master utility deletes and recreates model. | | + | ^ model | Restore the model database if: \\ * The master database has been rebuilt. \\ * The model database has been damaged, for example due to media failure. \\ * The model database has been modified, in this case, it is necessary to restore model from a backup when you rebuild master, because the Rebuild Master utility deletes and recreates model. | |
| - | | 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 ===== | ||
| + | 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. \\ \\ | ||
| + | - It is recommended to use ODBC backup mode for backup of database with a high volume of transaction, since such setup may require frequent backups. Transaction log backup (which is only supported by ODBC backup mode) can be performed periodically, and is less resource intensive than VSS based backup. \\ \\ | ||
| + | - For maximum data protection and restore options, it is recommended to configure: | ||
| + | - At least one offsite or cloud destination | ||
| + | - At least one local destination for fast recovery \\ \\ | ||
| + | - Perform test restores periodically to ensure your backup is set up and performed properly. Performing recovery test can also help identify potential issues or gaps in your recovery plan. It is important that you do not try to make the test easier, as the objective of a successful test is not to demonstrate that everything is flawless. There might be flaws identified in the plan throughout the test and it is important to identify those flaws. \\ \\ | ||
| + | - The Restore Raw File option is for advanced MS SQL Server administrator and should only be used if you have in-depth knowledge and understanding of your MS SQL Server, otherwise, it is not recommended to use this option as there are additional MS SQL techniques required to perform the manual restore. | ||
| ===== Documentation ===== | ===== Documentation ===== | ||
public/microsoft_sql_database.txt · Last modified: 2022/11/28 11:06 by kirk.lim