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,
We are planning to restore the databases on RDS SQL Server multi-AZ. it looks like we need to deploy the single-az before restoring the databases(full+diff+log) and modify it into multi-AZ once...
2
answers
0
votes
864
views
asked 5 months agolg...
Hello,
I have an ec2 where the RDP connection is corrupted i need at least to be able to take a backup from the database hosted on it, the remote access for the MS SQL server is not enabled, i need to...
1
answers
0
votes
795
views
asked 6 months agolg...
Description of problem:
ec2 instance with 3x volumes are used for MS SQL server (in window server): **
> One root volume is set up for 3 terabyte in aws, but actually 952 GB is not assigend (only...
1
answers
0
votes
745
views
asked 6 months agolg...
Hi,
We are doing the assessment using sct with filter for multiple servers but we have few database names with .(dot) (Example web_app.step1) . the filters are not considered the dot(.) and failed....
1
answers
0
votes
755
views
asked 6 months agolg...
hello, I have few 2008R2 SQL servers running on-prem that I intend to move to Amazon RDS for SQL. I want to know what are my options of doing so.
Option 1: Should I upgrade the on-prem to a supported...
2
answers
0
votes
734
views
asked 6 months agolg...
I am trying to migrate a SQL Server database hosted on an EC2 instance to an RDS SQL using DMS, but in the logs I get a particular error "The database 'rdsadmin' does not exist" which I do not...
1
answers
0
votes
1647
views
asked 6 months agolg...
Hello!
I have two RDS instances (AAAAA e BBBBB). Both instances belong to the same security group in EC2.
In the instance AAAAA created a linked server using the commands:
EXEC...
1
answers
0
votes
619
views
asked 6 months agolg...
I'm working on building custom data collection sets in RDS for SQL Server (NOT RDS Custom for SQL Server). RDS SQL limit even admin user to execute msdb system stored procedures like...
1
answers
0
votes
905
views
asked 6 months agolg...
I have enabled Database Activity Streams (DAS) on my MS SQL RDS instance to push audit logs to Kinesis Data Streams which is encrypted using a KMS key. I am looking for a way to push those logs to...
0
answers
0
votes
624
views
asked 6 months agolg...
I have an EC2 instance with sql server.
I also have GlobalAcelerator pointing to that instance.
If the accelerator works quickly, I can connect from anywhere else but after a few minutes it...
2
answers
0
votes
526
views
asked 7 months agolg...
Hi all,
I'm currently trying to duplicate a SQL Server EE database following the instructions here: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Procedural.Importing.html
The...
2
answers
0
votes
558
views
asked 7 months agolg...
Presently, we are only able to successfully create linked server connections using the IP address of the target systems; using hostnames and FQDNs does not work. We need to use FQDNs in order to...
0
answers
0
votes
470
views
asked 7 months agolg...