Questions tagged with Amazon RDS for SQL Server

Amazon RDS sets up, scales, deploys and manages administration of an SQL Server database in the cloud with just a few clicks.

Content language: English

Select tags to filter
Sort by most recent

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

128 results
Hey, I'm going to migrate from RDS to on-premise and im just curious is there any replacement or something simillar to pg_transport or is it available on on-premise postgresql
1
answers
0
votes
25
views
asked 5 days ago
Background I am working on data migration from an on-premises SQL Server database to an RDS SQL Server instance using AWS Glue. To facilitate this, I created a JDBC connection in AWS Glue to connect t...
1
answers
0
votes
50
views
asked 13 days ago
I'm experiencing an issue with my RDS database where the number of DatabaseConnections is significantly low, but the ConnectionAttempts are extremely high. Here are some details about my setup: 2 ins...
2
answers
0
votes
44
views
asked 19 days ago
I need to restore my RDS backups using AWS Backup for testing purposes. After the restore is complete, I want to automatically perform a validation test to compare the restored database with the sourc...
1
answers
0
votes
88
views
asked 2 months ago
Hi team, We are created Linked server on single-AZ RDS SQL server for Multi-AZ RDS SQL server. the Linked server some times test connection working and some time not working. we used Multi-az DNS nam...
2
answers
0
votes
40
views
asked 2 months ago
Hi Team, I have RDS MS SQL databases with gp3 storage. Storage usage at the databases is reaching 16 TB , so I need to devise a mechanism to archive the old data from multiple RDS MS SQL instances to...
1
answers
0
votes
64
views
AWS
asked 2 months ago
Hi Team, we recently migrated to RDS SQL server 2022 from SQL server 2019 ( Enterprise to Standard Edition). The application facing some slowness and when i am checking CPU usage and it less then 70%...
2
answers
0
votes
70
views
asked 2 months ago
Hi all, I have created foreign data wrappers for both RDS PostgreSQL and RDS SQL Server databases and can successfully read from these, so my issue does not relate at all to the connections here. Wha...
1
answers
0
votes
101
views
asked 3 months ago
What's the recommended way to expose subsets of database tables to external users? These users might have different AWS accounts, a separate cloud provider (e.g., GCP), or some other database managem...
4
answers
0
votes
67
views
asked 3 months ago
I am currently hosting SQL Server on EC2. SQL Server hosts 5 databases. Do I need to create a separate RDS instance one by one when migrating these databases to RDS? Or can I host it in one RDS ...
2
answers
0
votes
181
views
asked 3 months ago
I accidently deleted the rds admin user on a database (not the server instance). If i issue USE [database_name] I get Msg 916, Level 14, State 2, Line 1 The server principal "rdsadmin user" is not ab...
1
answers
0
votes
79
views
asked 3 months ago
Hi all, If automatic fail over of a multi-AZ RDS instance happens by updating DNS CNAMEs, can someone explain how and what is updated by RDS? Where are the CNAMEs located that are updated? And how ...
1
answers
0
votes
82
views
asked 3 months ago