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.
Thank you so much for the explanation.
You are welcome!
What happen when you removed the DB1 from the pool? is Azure will automatically assign a resource to that db?
yes
@@Niravgandhiyou saying yes but which service tier will choose??
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.
Coming weeks i m releasing video about db migration without downtime.
Understood but one thing u have removed db1 from elastic pool so what will be db service tier?
Normal tier
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?
Not getting you. Please provide details
can you migrate databases from On-premise to Azure Elastic pools ?
yes