0 votes
1 view
in AWS by (19.2k points)

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.


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.

1 Answer

0 votes
by (109k points)
edited by

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.

Related questions

Welcome to Intellipaat Community. Get your technical queries answered by top developers !