Amazon RDS SQL Server bring database online

Question

Having successfully taken a database instance offline using the Management Studio I then attempted it bring that same database back online both using the Management Studio and by executing the following script.

ALTER DATABASE [dbname] SET ONLINE

This results in the following error

User does not have permission to alter database 'dbname', the database does not exist, or the database is not in a state that allows access checks.

Answer 1

On RDS, you can use the SQL script above to take an instance offline. However, Amazon requires you to execute a stored procedure to bring it back online;

EXEC rdsadmin.dbo.rds_set_database_online dbname

If you want to learn more, check out this AWS Training Course by Intellipaat.