Elastic pools for Azure SQL database Module-4 | Azure Elastic Pool | 🔥 Free Azure SQL DBA Training🔥

[@maryamfatima5882]

Thank you so much for the explanation.

[@Niravgandhi]

You are welcome!

[@rakeshchauhan1496]

We are planning to move azure cloud for from my on premises setup On premises have server with SQL database with front and 200gb and database is 300gb. We need solution for zero down time. Mean one server down atleast start from another server because it is payroll application. Request you to guide me for SQL database redundancy solution in SQL.

[@Niravgandhi]

Coming weeks i m releasing video about db migration without downtime.

[@rajasekharreddygatta9343]

your removing db1 database from elastic pool, if any tables data in db1 it is shifted to db2. I hope I will get the answer?

[@Niravgandhi]

Not getting you. Please provide details

[@ranielgarcia8685]

What happen when you removed the DB1 from the pool? is Azure will automatically assign a resource to that db?

[@Niravgandhi]

yes

[@Absvenkatm]

​@@Niravgandhiyou saying yes but which service tier will choose??

[@Absvenkatm]

Understood but one thing u have removed db1 from elastic pool so what will be db service tier?

[@Niravgandhi]

Normal tier

[@sqljobs8548]

can you migrate databases from On-premise to Azure Elastic pools ?

[@Niravgandhi]

yes