Forum Discussion

AJ-AJ's avatar
AJ-AJ
Copper Contributor
Dec 17, 2025

Switch Azure SQL Provisioned to Serverless and back to Provisioned

Hi 

Can we switch Azure SQL from "Provisioned" to "Serverless" and back to "Provisioned" without any interruptions?  Wanted to observe how serverless works for a week. Data should never be lost while switching the mode (NOT a transactional data). Its more of nightly refresh and nothing much happening during day time. Its a retail dataWH. 

Currently im connecting to the below Azure SQL which is a provisioned instance. We are scaling up or down per our needs / work load and paying $X.

sql-xxxx-xxx-xxx-dev.database.windows.net

Nightly process runs at higher cores and then scales back to the lowest 2 core.

 

When someone queries tables, joins during day time, it takes 10-30 mins or so depending on the table size.

 

I'm wondering if i switch to serverless i would save money even if billed by seconds since nightly process runs 1hr and not much of querying every day during day time. i would like to test that. 

No RepliesBe the first to reply

Resources