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

Comments

Popular posts from this blog

System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out

Pre login Handshake or Connection Timeout Period

Transparent Data Encryption(TDE) with Master Key and Certificate in SQL Server