By using AWS re:Post, you agree to the Terms of Use

Questions tagged with Amazon Relational Database Service

Sort by most recent

Browse through the questions and answers listed below or filter and sort to narrow down your results.

How to rename a database (Not the instance) in mssql

I'm just trying to rename a created database on a 2019 MS SQL running on RDS. I have a database named `mydb` that for multi-tenant purposes, I need to rename to `mydb2` as a workaround for hardcoded values in the app. However, in SSMS, when i try to rename the database, I get this error: ``` TITLE: Microsoft SQL Server Management Studio ------------------------------ Unable to rename mydb2. (ObjectExplorer) ------------------------------ ADDITIONAL INFORMATION: Rename failed for Database 'mydb'. (Microsoft.SqlServer.Smo) For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=16.100.47021.0&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Rename+Database&LinkId=20476 ------------------------------ An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ User does not have permission to alter database 'mydb', the database does not exist, or the database is not in a state that allows access checks. (Microsoft SQL Server, Error: 5011) For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-5011-database-engine-error ------------------------------ BUTTONS: OK ------------------------------ ``` An using for forceful ways like changing the db to single-access, then altering the db doesn't work either because the error says my `admin` user doesn't have permissions to change that on a table. Is the background user `rdsadmin` logged in and preventing me from changing this? Could I restart the service and close any zombie connections? Maybe I make a copy of the database and give it another name? These seems like overkill but I'm not sure what permissions on RDS are preventing me.
1
answers
0
votes
19
views
asked 18 days ago

Can't Modify RDS Postgres "R6i" Stand-Alone instance to Multi-AZ, Fails

I am working on some terraform to launch RDS instances. As part of this project I need to import data from another database. The recommended setup from AWS to have a FAST `pg_restore` is to launch the RDS instance in Standalone mode for the import and then modify to Mutli-AZ there after. I have done this process before in my career and the methodology does work quite well. With this project we have chosen the R6i instance types as the match quite well with where we are migrating from. How ever I feel that we have found a bug in the AWS provisioning system. If you launch an RDS Postgres `db.r6i.24xlarge` instance type in the Stand-Alone Configuration and the modify it to be Multi-AZ you get the following error in the Web Console RDS - Log & Events Tab. ``` Instance type db.r6i.24xlarge in availability zone us-east-1c is unsupported; putting database instance into available ``` We know that to be false since the Main DB launched just fine. I have tested using the AWS Web Console instead of the Terraform code and I can reproduce this. I have also found via the Web Console that you can get a Multi-AZ DB, but only if you start with that configuration. So the steps to reproduce: 1. Launch a, RDS Postgres `db.r6i.24xlarge` instance in Stand-Alone. 2. After Completion; Modify the instance to be Multi-AZ. The process with take a little over 30 min, but then you will get the above error. My question: Is this a Bug?, and how can we get past it? Update: I also Attempted the same tests in the Default VPC. In the Default both Starting as a Mutli-AZ AND Starting as a Stand-Alone and Modify failed. :-(
1
answers
0
votes
31
views
asked 18 days ago