Skip to content

Instantly share code, notes, and snippets.

/gist:01b37896e78514958be5e51b603f88f5

Created November 21, 2016 00:07
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 anonymous/01b37896e78514958be5e51b603f88f5 to your computer and use it in GitHub Desktop.
Save anonymous/01b37896e78514958be5e51b603f88f5 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
import-module sqlps
$databasename = "Testdb01"
$PrimaryInstance = "sqlserver-0"
$SecondaryInstance = "sqlserver-1"
$DatabaseBackupFile = "\\sqlserver-1\backup\$DatabaseName.bak"
$LogBackupFile = "\\sqlserver-1\backup\$DatabaseName.trn"
$MyAgPrimaryPath = "SQLSERVER:\SQL\$primaryInstance\DEFAULT\AvailabilityGroups\alwayson-ag"
$MyAgSecondaryPath = "SQLSERVER:\SQL\$secondaryInstance\DEFAULT\AvailabilityGroups\alwayson-ag"
Backup-SqlDatabase -Database $DatabaseName -BackupFile $DatabaseBackupFile -ServerInstance $PrimaryInstance
Backup-SqlDatabase -Database $DatabaseName -BackupFile $LogBackupFile -ServerInstance $PrimaryInstance -BackupAction 'Log'
Restore-SqlDatabase -Database $DatabaseName -BackupFile $DatabaseBackupFile -ServerInstance $SecondaryInstance -NoRecovery
Restore-SqlDatabase -Database $DatabaseName -BackupFile $LogBackupFile -ServerInstance $SecondaryInstance -RestoreAction 'Log' -NoRecovery
Add-SqlAvailabilityDatabase -Path $MyAgPrimaryPath -Database $DatabaseName
Add-SqlAvailabilityDatabase -Path $MyAgSecondaryPath -Database $DatabaseName
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment