Explore Courses Blog Tutorials Interview Questions
0 votes
in AWS by (19.1k 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 (119k 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

Want to get 50% Hike on your Salary?

Learn how we helped 50,000+ professionals like you !

0 votes
1 answer
asked Mar 25, 2020 in AWS by Sudhir_1997 (55.6k points)
0 votes
1 answer

Browse Categories