Configuring Log Shipping
In this section, we'll learn to configure log shipping using SQL Server Management Studio. We'll be using the DPLPR, DPLDR, and DPLHA Hyper-V machines prepared in Lesson 4, AlwaysOn Availability Groups.
Note
Execute the C:\Code\Lesson05\10_Delete_AG_DPLAG.sql script to delete the DPLAG availability group. The script also deletes the Sales and Finance databases at DPLHA and DPLDR.
We'll log ship the Sales database from the primary instance, DPLPR, to the secondary instance, DPLHA.
Exercise 61: Configuring Log Shipping
To configure the log shipping setup, follow these steps:
- Connect to the VM DPLPR. Copy the C:\Code\Lesson06\CreateFolders.ps1 script to the C:\Scripts folder on DPLPR. Open a new PowerShell window on DPLPR and run the following command:
C:\Scripts\CreateFolders.ps1
The script creates a new Logshipshare directory in the C drive and shares it with read access to the DPL\Administrator user and a new directory, C:\DPLPRTlogs, at the secondary...