Questions tagged with Microsoft 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.
Hi everyone,
I intend to set up Windows Server 2022 with SQL server 2016 Standard, but AWS AMIs not support yet. So I intend to choose Windows Server 2022 Base and install SQL server 2016 by myself....
1
answers
0
votes
753
views
asked 10 months agolg...
Hi AWS, can anyone help me with the DR/DC guide for RDS SQL Server. What should be the ideal RTO and RPO for the same? Also how to achieve zero downtime in case the primary instance goes down or the...
2
answers
0
votes
660
views
asked 10 months agolg...
Hi Team,
I migrating the SQL server databases to the RDS SQL server using DMS ( Backups and restore + CDC) . last time I have the option to submit the LSN number in CDC start mode but this time I...
1
answers
0
votes
467
views
asked 10 months agolg...
Hi Team,
I am planning to do the Full load using DMS from the on-premises SQL server to the RDS SQL server. As we know full load only load the data and we need manually migrate the Views, stored...
1
answers
0
votes
435
views
asked 10 months agolg...
While creating on-premise SQL Server 2019 VM, we have the practice of creating data file and log file on separate volumes(physical drives), I believe equivalent here is EBS storage.
How do I put ...
1
answers
0
votes
338
views
asked 10 months agolg...
We know that our on-prem SQL Server 2019 Standard edition database uses
* Table Variables
* Loops
* Dynamic SQL using Exec or SP_executeSQL
* Temp Tables
* Geometry datatypes
* Geography datatypes
*...
1
answers
0
votes
248
views
asked 10 months agolg...
Hi,
im trying to setup a DMS Migration Task for ongoing replication from a EC2 hosted MsSql (2017) Server to S3. I followed this...
2
answers
0
votes
748
views
asked a year agolg...
We have a shared server and planning to migrate a few databases to EC2 and the remaining databases to the RDS SQL server. We are using Cloudamize to decide the instance type but it looks like...
1
answers
0
votes
327
views
asked a year agolg...
Hi
Does AWS have any guidance on how to enable TDE on SQL workloads deployed on EC2.
1
answers
0
votes
372
views
asked a year agolg...
The above-mentioned database is running a db.m4.4xlarge instance (16vCPU, 64GB RAM) .
But from the monitoring data of last 6 months, it looks heavily underutilized
![Enter image description...
1
answers
0
votes
474
views
asked a year agolg...
I understand from the SAP on AWS technical documentation, [Microsoft SQL Server for SAP NetWeaver on AWS Deployment and Operations...
1
answers
0
votes
1527
views
asked a year agolg...
Trying to set SQL Server source endpoint attribute:
`tlogAccessMode="PreferTlog"`
Getting:
`"SYSTEM ERROR MESSAGE:Invalid value provided for MicrosoftSQLServerSettings source field...
2
answers
1
votes
443
views
asked a year agolg...