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 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
658
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
466
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
433
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
336
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
246
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
747
views
asked 10 months 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
325
views
asked 10 months agolg...
Hi
Does AWS have any guidance on how to enable TDE on SQL workloads deployed on EC2.
1
answers
0
votes
370
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
473
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
1523
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
441
views
asked a year agolg...
Hi everyone,
When I try to create SQL server RDS with Microsoft SQL Server Windows Authentication setting:
![SettingDirectoryInRDS](/media/postImages/original/IM0YZxKGUMR1ekjHsX20LEVQ)
I receive the...
1
answers
0
votes
467
views
asked a year agolg...