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
642
views
asked 9 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
446
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
415
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
323
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
237
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
701
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
314
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
351
views
asked 10 months 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
444
views
asked 10 months 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
1491
views
asked 10 months 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
422
views
asked 10 months 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
451
views
asked 10 months agolg...