search

dataplat / dbatools

🚀 SQL Server automation and instance migrations have never been safer, faster or freer
https://dbatools.io
MIT License
2.44k stars 796 forks source link

Support Backup/Restore to Amazon S3 #9254

Open vanillagranilla opened 7 months ago

vanillagranilla commented 7 months ago

Summarize Functionality

S3 is now a supported backup destination in SQL Server 2022, similar to backup to Azure blob storage URL.

  1. For Backup-DbaDatabase: support backing up directly to S3 URL(s)
  2. For commands that Restore backups (Restore-DbaDatabase and Invoke-DbaAdvancedRestore), support restoring directly from S3 URL(s)
  3. For commands that list/find databases, verify that s3 URLS are accepted as input/output: Find-DbaBackup, Format-DbaBackupInformation, Get-DbaBackupInformation, probably others.

Is there a command that is similiar or close to what you are looking for?

Yes

Technical Details

Microsoft summary: https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/sql-server-backup-to-url-s3-compatible-object-storage?view=sql-server-ver16#restore-from-url

Just starting to investigate the work involved. We're open to starting to implement some of this functionality but would like to discuss first.