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

Source: Internet
Author: User
SQLSERVER back up the system database and when to back up the system database stores server configuration information, user logon information, user database information and job information before and after changing the server configuration and system database, the system databases to be backed up should be backed up in a timely manner: master, msdb, model, and distribution distributed backup

SQLSERVER back up the system database and when to back up the system database stores server configuration information, user logon information, user database information and job information before and after changing the server configuration and system database, the system databases to be backed up should be backed up in a timely manner: master, msdb, model, and distribution distributed backup

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.