Jagath4u
Jagath4u
/ Complete LRS in continuous mode.ps1
Created
February 23, 2022 19:07
Complete LRS in continuous mode
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Complete-AzSqlInstanceDatabaseLogReplay -ResourceGroupName "SQLMIJagathRG" ` | |
| -InstanceName "sqlmanagedinstancejagath" -Name "AdventureWorks2016" ` | |
| -LastBackupName "MY-PF2HM3EY_AdventureWorks2016_LOG_20211219_230104.trn" |
Jagath4u
/ Stop LRS in continuous mode.ps1
Created
February 23, 2022 11:28
Stop LRS in continuous mode
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Stop-AzSqlInstanceDatabaseLogReplay -ResourceGroupName "SQLMIJagathRG" ` | |
| -InstanceName "sqlmanagedinstancejagath" -Name "AdventureWorks2016" |
Jagath4u
/ Start LRS in continuous mode.ps1
Created
February 23, 2022 11:02
Start LRS in continuous mode
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Start-AzSqlInstanceDatabaseLogReplay -ResourceGroupName "SQLMIJagathRG" ` | |
| -InstanceName "sqlmanagedinstancejagath" -Name "AdventureWorks2016" ` | |
| -Collation "SQL_Latin1_General_CP1_CI_AS" ` | |
| -StorageContainerUri "https://storageaccountsqlmitest.blob.core.windows.net/sqlmibackup/AdventureWorks2016" ` | |
| -StorageContainerSasToken "mySASToken" |
Jagath4u
/ Monitor LRS in continuous mode.ps1
Last active
February 23, 2022 11:01
Monitor LRS in continuous mode
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Get-AzSqlInstanceDatabaseLogReplay -ResourceGroupName "SQLMIJagathRG" ` | |
| -InstanceName "sqlmanagedinstancejagath" -Name "AdventureWorks2016" |