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:01] ronnie.chan [Restore] |
||
|---|---|---|---|
| Line 269: | Line 269: | ||
| ^ System ^ Description ^ Backup ^ Suggestion ^ | ^ System ^ Description ^ Backup ^ Suggestion ^ | ||
| - | | master | The database that records all of the system level information of a SQL server system. | Yes | To back up 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. \\ \\ Back up the master database as often as necessary to protect the data sufficiently for your business needs. \\ \\ Microsoft recommends a regular backup schedule, which you can supplement with manual backup after any substantial update. | | + | ^ master | The database that records all of the system level information of a SQL server system. | Yes | To back up 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. \\ \\ Back up the master database as often as necessary to protect the data sufficiently for your business needs. \\ \\ Microsoft recommends a regular backup schedule, which you can supplement with manual backup after any substantial update. | |
| - | | model | The template for all databases that are created on the instance of SQL server. | Yes | Backup the model database only when necessary, for example, after customizing its database options. \\ \\ Microsoft recommends that you create only full database backups of model, as required. Because model is small and rarely changes, backing up the log is unnecessary. | | + | ^ model | The template for all databases that are created on the instance of SQL server. | Yes | Backup the model database only when necessary, for example, after customizing its database options. \\ \\ Microsoft recommends that you create only full database backups of model, as required. Because model is small and rarely changes, backing up the log is unnecessary. | |
| - | | msdb | The msdb database is used by SQL Server Agent for scheduling alerts and jobs, and for recording operators. It also contains history tables (e.g. backup / restore history table). | Yes | Back up the msdb whenever it is updated. | | + | ^ msdb | The msdb database is used by SQL Server Agent for scheduling alerts and jobs, and for recording operators. It also contains history tables (e.g. backup / restore history table). | Yes | Back up the msdb whenever it is updated. | |
| - | | tempdb | A workspace for holding temporary or intermediate result sets. This database is recreated every time an instance of SQL server is started. | No | The tempdb system database cannot be backed up. | | + | ^ tempdb | A workspace for holding temporary or intermediate result sets. This database is recreated every time an instance of SQL server is started. | No | The tempdb system database cannot be backed up. | |
| - | | distribution | The distribution database exists only if the server is configured as a replication distributor. \\ \\ It stores metadata and history data for all types of replication, and transactions for transactional replication. | Yes | Replicated databases and their associated system databases should be backed up regularly. | | + | ^ distribution | The distribution database exists only if the server is configured as a replication distributor. \\ \\ It stores metadata and history data for all types of replication, and transactions for transactional replication. | Yes | Replicated databases and their associated system databases should be backed up regularly. | |
| ==== 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