Skip to content

Latest commit

 

History

History
31 lines (29 loc) · 1.3 KB

README.md

File metadata and controls

31 lines (29 loc) · 1.3 KB
Raw

HadrWithDBATools

Slides and notebooks for Managing SQL Server HADR with DBATools This project contains two notebooks the following files.

LogShipping.ipynb

Sets up log shipping for a database

Requirements

  • Two instances of SQL Server
  • Agent Service Account must be an AD account
  • A file share to hold the log backups
  • Read/write permissions to the backup share for the primary Agent Service Account
  • Read permissions to the backup share for the secondary Agent Service Account
  • Read/write permissions to the copy destination for the secondary Agent Service Account
  • DBATools PowerShell module - run Install-Module DBATools from an Adminstrator PowerShell window to install the module

ConfigureAg.ipynb

Create a an Availability Group and Dynamic Network Name listener

Requirements

  • Two Windows servers running instances of SQL Server
  • Both instances should use the same paths for data and log files
  • Windows Server Failover Cluster containing the two SQL nodes wtih no shared storage
  • Enable Always On Availability Groups in SQL Server Configuration Manager for both instances
  • Grant the following permissions to NT AUTHORITY\SYSTEM
GRANT ALTER ANY AVAILABILITY GROUP TO [NT AUTHORITY\SYSTEM]
GO
GRANT CONNECT SQL TO [NT AUTHORITY\SYSTEM]
GO
GRANT VIEW SERVER STATE TO [NT AUTHORITY\SYSTEM]
GO