Questions tagged with Microsoft SQL Server
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
Does Microsoft SQL Server 2019 Standard on Windows Server 2019 include SSRS?
We are interested in adding an EC2 with Windows Server 2019 with Microsoft SQL Server 2019 Standard AMI. We want o add SSRS 2019 standard on the SQL Server instance. Does SSRS included in the AMI? If not, can we install SSRS 2019 standard without addition license? Thanks Amy
Migrate SQL Server DB (outside of AWS) to Aurora DB in AWS
I've created an empty Aurora DB inside AWS. I backed up my SQL Server DB and upload that backup to an S3 bucket. I thought I might be able to import that SQL Server backup either into my Aurora DB or into a SQL Server instance in AWS then migrate that to Aurora... I can't see how to do this. I've tried creating an endpoint, thinking I could use that to link to the SQL Server backup file but can't see a way. Is this possible or should I use a different approach?
Can't see Backup File location in SSMS on AWS FSx
I created 2 SQL failover server by using AWS FSx as the databases. But when I launched Microsoft SQL Server Management Studio, and tried to restored the database from AWS FSx, I can't see any files in the database location and can't see any file path. Do you have any suggestion to that then I can see the bakup files? Thanks.
RDS restore native backup and lazy loading from S3
On RDS for SQL Server, I understand that restores from EBS snapshots use lazy loading when downloading data from S3. If I restore a native backup file (.bak) from S3, will this use the same lazy loading as with snapshots or is all the data available on the instance once the restore is completed? Is lazy loading a feature of snapshot restores only?
RDS Performance Insights 'Slice By User' shows Unknown user generating DB load
I am using AWS RDS Performance Insights and am trying to establish who and what is generating DB load, when viewing 'Slice By User' I see the expected username of the DB connection cross-referenced with the host I am expecting, but I also see a large amount of load coming from the host generated by a user labelled as 'Unknown'. I am using SQL Server DB. Has anyone else experienced this or is able to explain why I would be seeing this behaviour? Thanks for any help
How AWS DMS CDC is working successfully without CDC On-premise MSSQL CDC prerequisites config?
We're using DMS for CDC Only migration for the time b/w point in time restore and current DB state, i.e AWS DMS to replicate changes as of the point in time at which you started your bulk load to bring and keep your source and target systems in sync. We've configured AWS DMS (CDC Only) with source endpoint to On-premise SQL Server 2012 (Standard Edition) and Target endpoint with AWS RDS MSSQL 2019 (Standard Edition). By looking into AWS CDC pre-requisites documentation https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.SQLServer.html#CHAP_Source.SQLServer.Prerequisites Running below query on on-premise MSSQL 2012 instance returns an error, ref: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.SQLServer.html#CHAP_Source.SQLServer.Prerequisites ``` use uat_testdb EXEC sys.sp_cdc_enable_db ``` Msg 22988, Level 16, State 1, Procedure sp_cdc_enable_db, Line 14 [Batch Start Line 0] This instance of SQL Server is the Standard Edition (64-bit). Change data capture is only available in the Enterprise, Developer, and Enterprise Evaluation editions. It looks ongoing replication CDC feature is supported only from MSSQL standard edition from 2016 SP1 and later. Could you please suggest if there any other workaround to complete CDC without upgrading our on-premise MSSSQL Standard Edition 2012 to Std Edition 2016 / Enterprise Edition? **However, without applying this CDC prerequisites config settings at on-premise DB instance, we can see the ongoing and replication b/w on-premise and RDS DBs instances statistics that shows sync updates of Inserts and Deletes. (Based on the testing target RDS DB instance sync. happening only for Insert and Delete operations of on-premise source db not for any updates) Could you please confirm/clarify if those CDC pre-requisites config are mandatory since we could see the replication successfully on DMS and why we're not getting any error /warning messages on AWS DMS for missing CDC prerequisites config. settings? Thanks.**()