Back

Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
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.

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.

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.5k points)
0 votes
1 answer
Welcome to Intellipaat Community. Get your technical queries answered by top developers!

28.4k questions

29.7k answers

500 comments

94.1k users

Browse Categories

...