Sqlserver back up the system database and when to back up the system database

Sqlserver back up the system database and when to back up the system database

The system database stores server configuration information, user logon information, user database information, and job information.

Back up servers before and after changing server configurations and System databases

The system databases to be backed up include:Master, MSDB, model, distributionDistribution

After backing up these databases, you can restore and restore the entire sqlserver database in the event of system faults, such as hard disk faults.

---------------------------------------Gorgeous split line-------------------------------------------------------------

When to back up the system database

1,After modifying the master database

The master database records the system-level information of the sqlserver system. The master must be backed up frequently to fully protect data based on business needs.

We recommend that you use a regular backup plan. In this way, you can add more backups after a large number of updates. When a user creates a user database,

When creating and modifying user logon accounts or executing any statements to change information in the master database, the master database should be backed up.

 

 

2,After modifying the MSDB Database

MSDB is a database used by the sqlserver agent to schedule alarms and jobs and record operator information.

Back up alarms, jobs, and operator information after modifying them. If you fail to back up the MSDB database in time,

After a system failure occurs, the user must reconstruct the alarms, jobs, and operators.

 

3,After modifying the model database

A model database is a template for all databases in the system. If you modify the model database to adjust the default configurations of all new user databases,

You must back up the model database to meet your business needs.

 

4,After the replication service is configured

The distribution database exists only when the server is configured as a replication distributor.

This database stores metadata, copies of historical data, and transactions used for transaction replication. After you configure the replication service,

The distribution database should be backed up in a timely manner to protect replication-related information.

 

This is so much. We may only back up our own business database and ignore the system database at ordinary times. So pay more attention to O (∩ _ ∩) O in the future.