Satya walks you through troubleshooting
storage-full errors in RDS

rds-out-of-storage-satya

My RDS database instance has run out of storage, and I can't stop, restart or connect to the instance.

An RDS DB instance in the STORAGE_FULL state won't have enough available space to perform basic operations, such as connecting to or restarting the instance.

Note: If your RDS DB instance is not in the STORAGE_FULL state, see Cannot Connect to Amazon RDS DB Instance before proceeding with the steps below.

  1. Determine the DB instance status using one of the methods described at DB Instance Status to confirm that the instance has a status of STORAGE_FULL.
  2. Complete the steps in the Amazon RDS DB Instance Running Out of Storage section of the Amazon RDS Troubleshooting documentation.
  3. To free up some space, apply a small increase to the Allocated Storage property of your DB instance per the instructions at Modifying an Amazon RDS DB Instance and Using the Apply Immediately Parameter.
    Note: A small increase to Allocated Storage is generally all you need to reconnect to the instance and perform additional troubleshooting.

If your DB instance is running the SQL Server engine, you cannot increment the Allocated Storage of your DB instance. The most common reasons for a sudden decrease in free storage for SQL Server are excessive transaction log growth or tempdb growth due to an operation that requires a large amount of tempdb space. Follow these steps to free up space on a DB instance running the SQL Server engine:

  • If you can connect to the DB instance, execute the DBCC SQLPERF(LOGSPACE) TSQL query to review the size of the SQL Server Transaction Log and the log space percentage used. If the log space percentage used is low, but the transaction log file size is high, consider shrinking the transaction log file to recover disk space by following the instructions at DBCC SHRINKFILE (Transact-SQL).
  • For reasons that you may be unable to connect to a DB instance running the SQL Server engine, see Cannot Connect to Amazon RDS SQL Server DB Instance.
  • The SQL Server tempdb grows automatically. If the tempdb is consuming a large amount of available storage, you can shrink it by following the instructions at Shrinking the tempdb Database.

Proactively implement measures to help prevent your RDS DB instance from running out of storage

To avoid the STORAGE_FULL state in the future, consider one or more of the following preventative measures:


Did this page help you? Yes | No

Back to the AWS Support Knowledge Center

Need help? Visit the AWS Support Center.

Published: 2015-10-13

Updated: 2017-02-23