Search code examples
sql-serverdatabaseamazon-web-servicesamazon-rdsrds

Increased backup file size when restoring SQL Server back up file to AWS RDS instance

I am experiencing this behaviour when I am trying to restore a sql server backup file to rds instance in aws. Backup file size is 4.6GB. When I restore this file to RDS instance, it works fine. But when I try to backup this rds instance, backup file generated is aroung 25GB.

I am not sure why file size is that much bigger than the original back up file size from SQL Server.

Any help is highly appreciated.

Solution

  • I assume backups are not compressed, that is why you get different size:

    exec rdsadmin.dbo.rds_show_configuration;

-- enabling
EXEC rdsadmin.dbo.rds_set_configuration 'S3 backup compression', 'true';