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
647
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
456
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
423
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
331
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
242
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
725
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
321
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
363
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
455
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
1506
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
432
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
460
views
asked a year agolg...