SQL Server 2014 SP2, backup and restore with powershell

I have a task where i have to take the backup with encryption and restore it to destination using the powershell.

I used the invoke-sql command and use the tsql in it but this command is not reliable for us rather we want to use the SQL powershell i.e backup-sqldatabase & restore sqldatabase.

my questions are what are the process to perform it (please i dont want to use invoke-sqlcmd)

  • create master using powershell ( i use “create master key encryption by password = ‘Abcd1234!'” in invoke-sqlcommand)
  • Create certificate using powershell
  • backup-certificate
  • create backup using encryption