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 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
439
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
407
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
318
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
231
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
677
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
309
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
343
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
435
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
1481
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
414
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
441
views
asked 10 months agolg...
Is there any Prescriptive guidance for Noisy neighbour multitenancy management on AWS RDS for SQL Server? Can I limit memory, cpu or storage per database per tenant created on AWS RDS for SQL Server?
0
answers
0
votes
96
views
asked 10 months agolg...