Browse the archive

AWS

MS SQL Express 2016 on Amazon AWS: I Can Take Database Offline but Can't Bring It Online

March 1, 20203 min read

Question I can take databases offline (via GUI) but can't bring them back online. The server details are as follow: RDBMS: MS SQL 2016 Express Host: Amazon AWS/RDS Free Tier Details/History of the Problem A few months ago, I created a db instance on Amazon …

Databases

Linked server from SQL server on AWS RDS to On premises MS SQL server database

October 7, 20192 min read

Question We are planing to migrate an on-premises SQL Server db to AWS RDS SQL Server. My only concern is how can I create a linked server from AWS RDS SQL Server to on-premises SQL Server db? Is it possible? I am checking it because there are many views …