Question: What happens to a SQL Server RDS instance if the databases increase in size and go over the allocated space?

  1. RDS will automatically increase the allocated space by 10% and will send the AWS root account an email with resolution steps. Allocate more space to avoid overage charges.
  2. The database instance will report a STORAGE_FULL status and become inaccessible if the instance does not have enough remaining storage to operate. Allocate more space to the instance.
  3. SQL Server will close all existing connections to the databases and attempt to shrink its log files to reclaim storage space.
  4. RDS will automatically increase the allocated space by 5% and will continue to allocate new space up to 50% of the orginal allocated space. When storage space has increase 50%, RDS will automatically stop the instance to preserve data integrity.

Answer: The correct answer of the above question is Option B:The database instance will report a STORAGE_FULL status and become inaccessible if the instance does not have enough remaining storage to operate. Allocate more space to the instance.