Stack Overflow Asked by Sameer on February 21, 2021
How to migrate SQL Server Instance from Local Instance to Azure VM SQL Server Instance?
Seeking for experts support resolving following issue.
Scenario:
LocalInstance: SQLSRV01
Azure VM: 23.96.20.20
-Local SQL SERVER and Azure VM SQL SERVER Instance are of SQLSERVER 2017 (14.0)
-Added Inbound port rule for sql server
-SharedPath accessible from both sides ( Local computer as well as from Azure VM: 23.96.20.20 )
-DBSERVER17 instance is accessible and connected from local computer
-Same command worked well at my local computer with two different SQL SERVER Instances.
Power Shell Script:
$params = @{
Source = "SQLSRV01"
Destination = "23.96.20.20"
SharedPath = "Z:"
BackupRestore = $true
}
Start-DbaMigration @params -Force | Select * | Out-GridView
Output Received:
PS C:WINDOWSsystem32> E:PowerShellScriptsRemoteInstance.ps1
WARNING: [16:05:58][Copy-DbaSpConfigure] Error occurred while establishing connection to 23.96.20.20 | The wait operat
ion timed out
WARNING: [16:06:15][Copy-DbaCustomError] Error occurred while establishing connection to 23.96.20.20 | The wait operat
ion timed out
WARNING: [16:06:15][Copy-DbaCredential] Console not elevated, but elevation is required to perform some actions on loc
alhost for this command.
WARNING: [16:06:15][Copy-DbaDbMail] Error occurred while establishing connection to 23.96.20.20 | The wait operation t
imed out
WARNING: [16:06:15][Copy-DbaRegServer] Error occurred while establishing connection to 23.96.20.20 | The wait operatio
n timed out
WARNING: [16:06:15][Copy-DbaBackupDevice] Error occurred while establishing connection to 23.96.20.20 | The wait opera
tion timed out
WARNING: [16:06:15][Copy-DbaInstanceTrigger] Error occurred while establishing connection to 23.96.20.20 | The wait op
eration timed out
WARNING: [16:06:15][Copy-DbaDatabase] Error occurred while establishing connection to 23.96.20.20 | The wait operation
timed out
WARNING: [16:06:15][Copy-DbaLogin] Error occurred while establishing connection to 23.96.20.20 | The wait operation ti
med out
The wait operation timed out
At C:Program FilesWindowsPowerShellModulesdbatools1.0.113allcommands.ps1:83435 char:9
throw $records[0]
~~~~~~~~~~~~~~~~~
CategoryInfo : NotSpecified: (:) [], Exception
FullyQualifiedErrorId : dbatools_Connect-DbaInstance
Supplied parameters $scred, $dcred then passed $scred object to the SourceSqlCredential and passed $dcred object to the DestinationSqlCredential that's it.
$scred = Get-Credential
$dcred = Get-Credential
$params = @{
Source = "SQLSRV01"
Destination = "23.96.20.20"
SourceSqlCredential = $scred
DestinationSqlCredential =$dcred
SharedPath = "\SharedDB"
BackupRestore = $true
}
Start-DbaMigration @params -Force | Select * | Out-GridView
Correct answer by Sameer on February 21, 2021
Get help from others!
Recent Answers
Recent Questions
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP