SCDPM 2016 backup of SQL Server 2016

Backup SQL Server 2016 under SCDPM2016

We introduced some about SCDOM2016, SCOM2016 of the relevant configuration introduction, that today is about to use SCDPM2016 Backup SQL Server 2016 server, of course, the general use of SCDPM will also back up the Exchange database and other services When it comes to backup, there are many ways to make backups, such as the Windows Server Backup tool that comes with the system, the backup tools that Symantec provides, the SCDPM for backup, and, of course, some other third-party backup tools, Today we are introducing a backup using SCDPM2016. For SQL Server data backup, in fact, usually use the backup plan of SQL Server for data backup, after backup can directly restore the database, it is relatively convenient, of course, the way of backup mainly depends on the user's usage habits, specifically not to say, specifically, see below:

We first install the backup service on SQL Server2016

650) this.width=650; "title=" clip_image002 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image002 "src=" http://s3.51cto.com/wyfs02/M02/79/91/wKioL1aU946QHDnaAADwDPwMBC0542.jpg "height=" 484 "/>

Installation Successful

650) this.width=650; "title=" clip_image004 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image004 "src=" http://s3.51cto.com/wyfs02/M02/79/91/wKioL1aU95CglRgqAACvKOI0HZY064.jpg "height=" 484 "/>

Next install the agent; we need to install the SCDPM agent for SQL Server

650) this.width=650; "title=" clip_image006 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image006 "src=" http://s3.51cto.com/wyfs02/M00/79/91/wKioL1aU95LBKuQmAACmilUFXK4433.jpg "height=" 422 "/>

We choose according to our own environment, install the agent

650) this.width=650; "title=" clip_image008 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image008 "src=" http://s3.51cto.com/wyfs02/M00/79/91/wKioL1aU95zDSahJAAD18EvmH9s925.jpg "height=" 484 "/>

Add a SQL Server server

650) this.width=650; "title=" clip_image010 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image010 "src=" http://s3.51cto.com/wyfs02/M01/79/93/wKiom1aU92-it6O_AADhHBJGUDc452.jpg "height=" 484 "/>

Fill in authentication credentials

650) this.width=650; "title=" clip_image012 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image012 "src=" http://s3.51cto.com/wyfs02/M02/79/91/wKioL1aU96HhqcciAADMzK0lr80146.jpg "height=" 484 "/>

Prompt warning message

650) this.width=650; "title=" clip_image014 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image014 "src=" http://s3.51cto.com/wyfs02/M00/79/91/wKioL1aU96Og3BQ3AAD665OSWWk434.jpg "height=" 484 "/>

After installing the agent, the system restart mode

650) this.width=650; "title=" clip_image016 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image016 "src=" http://s3.51cto.com/wyfs02/M00/79/93/wKiom1aU93WxWcoqAADaf74_MNw482.jpg "height=" 484 "/>

Start Installation Agent

650) this.width=650; "title=" clip_image018 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image018 "src=" http://s3.51cto.com/wyfs02/M01/79/91/wKioL1aU96fiHxH3AACy33mEUjw106.jpg "height=" 484 "/>

Agent Installation Complete

650) this.width=650; "title=" clip_image020 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image020 "src=" http://s3.51cto.com/wyfs02/M01/79/93/wKiom1aU93jAwWIEAACvrXnPzM8792.jpg "height=" 484 "/>

We can view the status of the installation in the agent state

650) this.width=650; "title=" clip_image022 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image022 "src=" http://s3.51cto.com/wyfs02/M00/79/91/wKioL1aU96rgg_sSAADnAa2SPTg935.jpg "height=" 475 "/>

Next we create a new protection group to host the protection work for SQL Server; Click Protect---New

650) this.width=650; "title=" clip_image024 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image024 "src=" http://s3.51cto.com/wyfs02/M02/79/91/wKioL1aU96yB7_-CAADr-_8Tlx8421.jpg "height=" 484 "/>

We choose a backup of the server type

650) this.width=650; "title=" clip_image026 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image026 "src=" http://s3.51cto.com/wyfs02/M02/79/93/wKiom1aU933RsbMjAADVsDonNKc541.jpg "height=" 471 "/>

Select the backed up data information-here we check the database information of SQL Server for backup;

Of course, we can also check the backup system status and other information

650) this.width=650; "title=" clip_image028 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image028 "src=" http://s3.51cto.com/wyfs02/M02/79/92/wKioL1aU97KytYNwAAE13aGLv18126.jpg "height=" 466 "/>

Fill in the Protection group name

650) this.width=650; "title=" clip_image030 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image030 "src=" http://s3.51cto.com/wyfs02/M00/79/93/wKiom1aU94TiLgtaAADUVVyZ_oY878.jpg "height=" 484 "/>

Define Backup target Information

650) this.width=650; "title=" clip_image032 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image032 "src=" http://s3.51cto.com/wyfs02/M00/79/93/wKiom1aU94Wyqf6oAADp_hvysTg606.jpg "height=" 468 "/>

We define a full backup, 11.00 in Tuesday for backup

650) this.width=650; "title=" clip_image033 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image033 "src=" http://s3.51cto.com/wyfs02/M01/79/92/wKioL1aU97fwyZlXAADqEKlIVxw417.jpg "height=" 468 "/>

Summary information

650) this.width=650; "title=" clip_image035 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image035 "src=" http://s3.51cto.com/wyfs02/M01/79/92/wKioL1aU97nBTitZAAD6Ib17D_E644.jpg "height=" 466 "/>

Define how replicas are created

650) this.width=650; "title=" clip_image037 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image037 "src=" http://s3.51cto.com/wyfs02/M02/79/92/wKioL1aU97rQD3kGAADMwopK2nE747.jpg "height=" 465 "/>

One-time check option for replicas

650) this.width=650; "title=" clip_image039 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image039 "src=" http://s3.51cto.com/wyfs02/M02/79/92/wKioL1aU97-Ah48RAADxAUdlib4899.jpg "height=" 484 "/>

summary information; Prepare a backup

650) this.width=650; "title=" clip_image041 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image041 "src=" http://s3.51cto.com/wyfs02/M00/79/93/wKiom1aU95Gg2ommAADfAK80Xz4045.jpg "height=" 484 "/>

650) this.width=650; "title=" clip_image043 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image043 "src=" http://s3.51cto.com/wyfs02/M01/79/92/wKioL1aU98ODchVeAADjiJTt4yg499.jpg "height=" 484 "/>

Start creating a protection group

650) this.width=650; "title=" clip_image045 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image045 "src=" http://s3.51cto.com/wyfs02/M01/79/93/wKiom1aU95WCsMtkAADtICoHSQQ625.jpg "height=" 484 "/>

Protection group Creation Complete

650) this.width=650; "title=" clip_image045[1] "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ IMAGE045[1] "src=" http://s3.51cto.com/wyfs02/M01/79/92/wKioL1aU98ezTOuOAADtICoHSQQ002.jpg "height=" 484 "/>

After we have created the protection group, we are prompted not to configure protection

650) this.width=650; "title=" clip_image047 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image047 "src=" http://s3.51cto.com/wyfs02/M02/79/92/wKioL1aU98mj-pWiAAEpIV32rNI424.jpg "height=" 484 "/>

We view the cause of the error by monitoring the prompt information;

SDPM agent does not have sysadmin privileges

650) this.width=650; "title=" clip_image049 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image049 "src=" http://s3.51cto.com/wyfs02/M00/79/93/wKiom1aU953zbSZ7AAFvkudtGco835.jpg "height=" 484 "/>

First create the SQL login for the account, and then add it to the sysadmin group.

We log in to SQL SERVER Manage Studio Admin Center---Security-logins-Right click-New login account

650) this.width=650; "title=" clip_image051 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image051 "src=" http://s3.51cto.com/wyfs02/M01/79/93/wKiom1aU957T17xMAAC9Rt_QIFQ808.jpg "height=" 484 "/>

Login Name: NT SERVICE\DPMRA

650) this.width=650; "title=" clip_image053 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image053 "src=" http://s3.51cto.com/wyfs02/M00/79/92/wKioL1aU99HR162aAAD8aGkK9Og213.jpg "height=" 484 "/>

Server role----Tick sysadmin

650) this.width=650; "title=" clip_image055 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image055 "src=" http://s3.51cto.com/wyfs02/M00/79/93/wKiom1aU96PQZdk_AADsyvfecCY989.jpg "height=" 484 "/>

Once created, we look at member information under the sysadmin group

650) this.width=650; "title=" clip_image057 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image057 "src=" http://s3.51cto.com/wyfs02/M01/79/92/wKioL1aU997AdoCpAAEBz5bJayg204.jpg "height=" 484 "/>

Create complete

650) this.width=650; "title=" clip_image059 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image059 "src=" http://s3.51cto.com/wyfs02/M02/79/92/wKioL1aU9-CiPaA-AADSpld3eDM999.jpg "height=" 484 "/>

When we add the above permissions, we see that the status of the protection group is automatically updated

650) this.width=650; "title=" clip_image061 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image061 "src=" http://s3.51cto.com/wyfs02/M00/79/92/wKioL1aU9-KQuUQ5AAEE_XH0F8E861.jpg "height=" 458 "/>

We found two warnings are prompt, replica inconsistent, prompting is verifying

650) this.width=650; "title=" clip_image063 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image063 "src=" http://s3.51cto.com/wyfs02/M02/79/92/wKioL1aU9-SCIpsnAADaqmd5ZIc613.jpg "height=" 458 "/>

After a few minutes of verification, the data will all be fine.

650) this.width=650; "title=" clip_image065 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px, "border=" 0 "alt=" clip_ image065 "src=" http://s3.51cto.com/wyfs02/M01/79/93/wKiom1aU97XTuMITAAD3kHDF1c0803.jpg "height=" 484 "/>

This article from "Gao Wenrong" blog, declined reprint!

SCDPM 2016 backup of SQL Server 2016