Skip to content

Instantly share code, notes, and snippets.

@MikeFal

MikeFal/AGBackups.ps1

Created November 23, 2016 18:46
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save MikeFal/3e9416b5624880b9f36c77deecd2b36d to your computer and use it in GitHub Desktop.
Save MikeFal/3e9416b5624880b9f36c77deecd2b36d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
AGBackups.ps1
Import-Module SqlServer,FailoverClusters
$PrimaryNode = 'PICARD'
$nodes = (Get-Cluster -Name $PrimaryNode | Get-ClusterNode).Name
$nodes | ForEach-Object {Get-SqlDatabase -ServerInstance $_} | Select-Object Parent,name,LastBackupDate,LastLogBackupDate | Out-GridView
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment