Wednesday, October 7, 2015

Creating an Online or Offline Secondary Database using PowerShell Commands

a. To create an online Secondary Database

Start-AzureDqlDatabaseCopy -ServerName "<Secondary Server Name>"
                           -DatabaseName "<Database Name>"
                           -PartnerServer "NewServer"
                           -ContinuousCopy

b. To create an Offline Secondary Database

Start-AzureDqlDatabaseCopy -ServerName "<Secondary Server Name>"
                           -DatabaseName "<Database Name>"
                           -PartnerServer "NewServer"
                           -ContinuousCopy
                           -OfflineSecondary   

No comments:

Post a Comment