Dropping database in RDS follows different method than dropping the database in local SQL Server. Below is the command to DROP the database in Amazon RDS EXECUTE msdb.dbo.rds_drop_database N'demodb' GO However when the SQL Server is configured with Multi-zone mirroring, then you need to set the partner to OFF and drop all active connections and […]
2020-01-17
1,299 reads
An introduction to SQL Server for Red Hat Linux Administrators with a step by step installation.
2016-12-27
1,429 reads
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By kleegeek
I am thrilled to have been a part of this year’s Storage Field Day...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Hello, I have a requirement to migrate the data from existing AWS RDS DB...
I'm having some trouble wrapping my head around the relationship between EC2 instances and...
Hello All, I have a table like below. I need to get daily,weekly and...
Ask SSC