Questions tagged with Microsoft SQL Server
The proven, reliable, secure cloud for SQL Server
Content language: English
Select up to 5 tags to filter
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
I have successfully restored an RDS snapshot, and AWS has generated the instance in my RDS list. However, I am encountering difficulties connecting to the database from SQL Server Management Studio as...
Hi AWS, I have to build the CI/CD pipeline for the database schema running on Amazon Hosted RDS SQL Server 2022. I have a couple of questions for the same:
1. The cluster is not publicly accessible,...
Hi All,
We have allocated 100 GB storage to RDS, and max storage size is 150 GB. do we change to 100 GB or 150 GB?
Hello, We have around 10 databases and planning to migrate to RDS SQL Server(2 RDS). currently we have 4 CPU and 16 GB RAM. How to decide the right sizing for RDS instance . do we have any queries to...
Hi!
I have a Windows EC2 Server that runs an application that relies on SQL Server. The application installer installs SQL Server Express as part of the installation. I am hoping to upgrade it in...
I've created RDS Sql Server Agent Scheduled Jobs with the role 'SQLAGENTUSERROLE' and configured RDS to publish agent logs to Cloud Watch Console but the Logs were not getting published in the...
Hi Team,
Can we restore the SQL server databases with file stream on custom RDS. Please share any AWS links, Thanks in Advance.
Very simply, I just need to locate instructions for creating a SQL Server AlwaysOn Availability Group in AWS. It is purely for testing purposes. I've been told by many people that it can be done,...
SSIS tasks can be configured on a SQL Server RDS instance. Can a task be created to access an FSx For Windows file share to read files and load into a table?
We have a single RDS instance for MS SQL. I have been successfully using a third-party SQL backup tool to perform native SQL backups. To achieve this I added GRANT BACKUP DATABASE permissions to the...
A failover occurred 10 days ago, and since then, the Query Store has not been collecting any new data. After running the sp_query_store_consistency_check, I encountered the following error: 'Query...
Hi Team,
As we know, file stream databases are not supported in RDS, so we plan to custom RDS SQL Server. I think it will be the same as on-premises. could you please share any AWS links for...