public:microsoft_sql_database
Differences
This shows you the differences between two versions of the page.
| Both sides previous 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:01] ronnie.chan [Restore] |
||
|---|---|---|---|
| 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]] | |
| ===== Documentation ===== | ===== Documentation ===== | ||
public/microsoft_sql_database.txt · Last modified: 2022/11/28 11:06 by kirk.lim