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.
Customer asked in a RFP the ability to use `named instances` with RDS for Microsoft SQL Server. It probably sound obvious to specialists, is this the `DB Instance identifier` we pass at the RDS...
1
answers
0
votes
736
views
I am using MS-SQL Server 2012 and 2016 on-prem. I want to capture CDC from this database and load it into Redshift using DMS. Since our tables have primary keys, MS-Replication seems to be the only...
1
answers
0
votes
1961
views
I have a customer who is planning a migration from on-prem SQL-Server to EC2 SQL Server using DMS. They want to know what will happen in the event the SQL Server AG fails over (on-prem to on-prem...
1
answers
0
votes
825
views
asked 4 years agolg...
While migrating from SQL Server or Sybase database to PostgreSQL, how do you convert a stored procedure with return status and check if procedure call is successful.
Sample example:
EXEC...
1
answers
0
votes
520
views
asked 4 years agolg...
Hi,
What is the best practice for migrating an RDS instance from SQL Server Standard Edition to SQL Enterprise Edition?
Thanks,
1
answers
0
votes
1270
views
asked 4 years agolg...
A customer is exploring RDS SQL server. The RDS SQL Server documentation (https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Procedural.Importing.html) states that “Native backups of RDS...
1
answers
0
votes
389
views
For SQL Server running on EC2 and using FSx, when the FSx maintenance window happens, will there be an interruption to SQL Server ? Do the databases become disconnected?
1
answers
0
votes
559
views
asked 4 years agolg...
1. Can I stop/resume replication for a RDS SQL Server Read Replica, like we do with on-prem SQL Server?
2. is there any recommended max db size for a replication to occur smoothly?
3. is there any...
1
answers
0
votes
1018
views
asked 4 years agolg...
I'm testing Linked Server on RDS SQL Server to point to existing SQL Server (non RDS). Test connection throw error with the following message :
------------------------------
ADDITIONAL...
1
answers
0
votes
1213
views
Is there a work around to scaling an RDS MS SQL Server instance type/size down (with no downtime) without building out a new RDS instance from a snapshot as that has down time?
Thank you.
1
answers
0
votes
1672
views
asked 5 years agolg...
A customer is running SQL Server Standard 2012 on an i2.xlarge instance. He wants to upgrade to i3.xlarge and SQL Server Standard 2017.
Are there any issues with SQL server and changing the instance...
1
answers
0
votes
893
views
Hello,
When I use the RDP session I only see one Command Prompt window. I don't see a Windows UI. Is this AMI bad?
Additionally, I'm trying to remotely connect to the SQL Server that is...
3
answers
0
votes
233
views
asked 5 years agolg...