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
- create backup using encryption