SQL Server 2014 Log Shipping Deployment (3): Log Shipping initialization configuration

13.2.3 Deployment Log Shipping Initial Configuration

Some initial configuration is required before the log shipping is deployed. You need to configure shared folders for replication of transaction log backups and backups, set up an agent run account and the primary DB instance to run the account, and configure the account to have read and write access to the shared folder.

(1) Create a shared folder for the backup log, ensure that the primary and secondary servers are able to access the shared folder properly, create the D:\BackupLog folder on the domain-controlled ad, and share it. The UNC address of this shared folder can be accessed on the primary server and the secondary server \\ad\backuplog or \\192.168.1.20\backuplog, the SQL Agent running account on the primary server and the primary DB instance running the account have read and write access to the file holder. The SQL Agent account on the secondary server has Read permission to this folder.

Create D:\copylog on the secondary server SQLSVR2 to replicate the backup log to the secondary server locally.

(2) In SQL Server Configuration Manager on the primary server, primary DB instance, secondary server, and monitoring server, locate SQL Server Agent, open its properties page and set the SQL Proxy server account to localdomain\ Administrator The experimental environment can be set up to facilitate the management of agents and agents in the operation of various types of operations; In a production environment, create an account specifically for the SQL Agent, with minimal account permissions set.

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m00/57/fa/wkiol1slou3hbtvnaagdwkeenm0656.jpg "height=" 552 "/>

(3) Setting the primary database on the primary server DB01 the recovery mode to full or bulk-logged mode, using Management Studio in the DB01 Database Properties "Options" page, modify the recovery mode to full or large capacity mode;

650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m01/57/fa/wkiol1slov6qnv3baajfutdsb58308.jpg "height=" 564 "/>

This article is from the "Margin with Wish" blog, please be sure to keep this source http://281816327.blog.51cto.com/907015/1598312

SQL Server 2014 Log Shipping Deployment (3): Log Shipping initialization configuration