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.

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 (101k 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 !


Categories

...