Venugopal Saride


Technical Article

Amazon RDS SQL Server - Drop Database with Mirroring

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 […]

5 (1)

2020-01-17

1,299 reads

Blogs

Daily Coping 17 May 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Storage Field Day 23 – HammerSpace

By

I am thrilled to have been a part of this year’s Storage Field Day...

Daily Coping 16 May 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Migration of Data from one Database to Multiple Databases

By vamshi.sql

Hello, I have a requirement to migrate the data from existing AWS RDS DB...

AWS Beginner questions

By cariebens

I'm having some trouble wrapping my head around the relationship between EC2 instances and...

How to get weekly and Monthly view from daily in sql server

By Krish319

Hello All, I have a table like below. I need to get daily,weekly and...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers