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.
I need the MSSQL database service, in this service I will upload some database backups, and then my tool will select all the data in the table, do some processing of these data for another instance of...
1
answers
0
votes
318
views
asked 8 months agolg...
Hi ,
I need to create the SQL server user with minimum permissions to configure the ongoing replication.
We plan to migrate the SQL server databases to AWS using DMS+CDC when I am checking the AWS...
2
answers
0
votes
411
views
asked 8 months agolg...
we have configure aws rds with microsoft sql server.
when we try to access model db,it throws error as "The server principal "name" is not able to access the database "model" under the current...
1
answers
0
votes
416
views
asked 8 months agolg...
Hello team,
I have SQL Server named instance - SQLExpress running on localhost, I can connect to that instance using DBeaver but cannot connect using AWS SCT. I have specified JDBC Driver as...
2
answers
0
votes
331
views
asked 8 months agolg...
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
691
views
asked 8 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
598
views
asked 8 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
394
views
asked 9 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
370
views
asked 9 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
291
views
asked 9 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
213
views
asked 9 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
599
views
asked 9 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
288
views
asked 9 months agolg...