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.
@Niravgandhi2 жыл бұрын
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
@ranielgarcia86852 жыл бұрын
What happen when you removed the DB1 from the pool? is Azure will automatically assign a resource to that db?
@Niravgandhi2 жыл бұрын
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 ?