Advertisement
Guest User

Untitled

a guest
Mar 16th, 2017
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.98 KB | None | 0 0
  1. $dbUser = "tester"
  2. $dbPass = "myP@ssword"
  3. $primaryServerName = "serverName"
  4. $primaryDbName = "dbName"
  5. $resourceGroupName = "groupName"
  6. $secondaryServerName = "secondary" + (Get-Random)
  7.  
  8. $existingDb = Get-AzureRmSqlDatabase -ServerName $primaryServerName -DatabaseName $primaryDbName `
  9. -ResourceGroupName $resourceGroupName
  10.  
  11. # Create secondary server
  12. $securePass = ConvertTo-SecureString -String $dbPass -AsPlainText -Force
  13. $dbCredentials = New-Object -TypeName "System.Management.Automation.PSCredential" -ArgumentList $dbUser, $securePass
  14. $serverSecondary = New-AzureRmSqlServer -ServerName $secondaryServerName `
  15. -ResourceGroupName $existingDb.ResourceGroupName -Location "West Europe" `
  16. -SqlAdministratorCredentials $dbCredentials
  17.  
  18. # Activate geo-replication
  19. $existingDb | New-AzureRmSqlDatabaseSecondary `
  20. -PartnerServerName $secondaryServerName `
  21. -PartnerResourceGroupName $existingDb.ResourceGroupName
  22. # To allow connections to your secondary DB just add -AllowConnections All
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement