Many libraries and packages exist to aid with the SFTP connection, database restoration, and task automation. A few that we recommend are:
- SqlServer - published by Microsoft as native PowerShell functionality. Can be used to manage, manipulate, and restore databases programmatically: https://docs.microsoft.com/en-us/powershell/module/sqlserver/?view=sqlserver-ps
- WinSCP - PowerShell library specializing in SFTP connections: https://winscp.net/eng/docs/library_powershell
- Windows Task Scheduler - Run any task, including PowerShell scripts, at a specific time or in response to specific triggers: https://msdn.microsoft.com/en-us/library/windows/desktop/aa383614(v=vs.85).aspx
Additionally, for any manual file manipulation or transfer, FIleZilla is recommended. For more information about how to use FileZilla, please review the How do I access my FTP or Blackbaud Hosting Services Files Folder using FileZilla?
Note: Blackbaud will not provide support for the extraction of data from the .bak file using these methods