Search icon CANCEL
Subscription
0
Cart icon
Cart
Close icon
You have no products in your basket yet
Save more on your purchases!
Savings automatically calculated. No voucher code required
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Professional SQL Server High Availability and Disaster Recovery

You're reading from  Professional SQL Server High Availability and Disaster Recovery

Product type Book
Published in Jan 2019
Publisher Packt
ISBN-13 9781789802597
Pages 564 pages
Edition 1st Edition
Languages
Concepts
Author (1):
Ahmad Osama Ahmad Osama
Profile icon Ahmad Osama
Toc

Table of Contents (9) Chapters close

Professional SQL Server High Availability and Disaster Recovery
Preface
1. Getting Started with SQL Server HA and DR 2. Transactional Replication 3. Monitoring Transactional Replication 4. AlwaysOn Availability Groups 5. Managing AlwaysOn Availability Groups 6. Configuring and Managing Log Shipping Appendix

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:

  1. 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 instance DPLHA. This...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at €14.99/month. Cancel anytime