Restoring database .BAK file in Azure SQL Managed instance with PowerShell module dbatools
The script will not RESTORE the database, it will generate script for RESTORE and we can copy and paste it in SSMS. cls $Username = 'UserNameHere' $Password = ConvertTo-SecureString -String 'Password' -AsPlainText -Force $Creds = New-Object ` -TypeName System.Management.Automation.PSCredential( $Username , $Password ) Get-DbaDatabase ` -sqlinstance 'managedInstanceNameHere.database.windows.net' ` -SqlCredential $Creds <# The value that we have provided for -Path parameter is need to taken from teh .bak file properties url not from container and storage. #> Restore-DbaDatabase ` -SqlInstance 'managedInstanceNameHere.database.windows.net' ` -SqlCredential $Creds ` -DatabaseName TEST ` -Path 'Take the backp file(.bak) path properties URL ' ` -OutputScriptOnly ` -Verbose
