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