Is it possible to add a PaaS DB in Business Critical tier to a General Purpose elastic pool?

Sijad Malik 21 Reputation points

Is it possible to add a PaaS DB in the Business Critical tier to an elastic pool in the General Purpose tier? When I try to do this I get an error message.

We are trying to add 2 General Purpose DB's and 2 Business Critical DB's into a single General Purpose elastic pool. Is this possible to have databases that are in different tiers to a General Purpose elastic pool?


Azure SQL Database
0 comments No comments
{count} votes

Accepted answer
  1. Anurag Sharma 17,386 Reputation points

    Hi anonymous user, welcome to Microsoft QnA forum.

    Adding a Business Critical Database to General Purpose Elastic Pool is allowed as any other database but once you add, the business critical database will be scaled down to General Purpose Elastic Pool. That means storage limits and cost are applicable as per the General Purpose Elastic pool only.

    After adding the database, if you go back and check the activity log of Business critical database, you can see the changes as below:
    Yellow - Old values
    Green - New values


    Again if you try to scale up the database from General Purpose Elastic Pool to Business Critical, this database will be removed from the elastic pool.

    Please let us know if this helps.

1 additional answer

Sort by: Most helpful
  1. Alberto Morillo 27,791 Reputation points MVP

    Please try to move those databases to the elastic pool by using the following T-SQL statement:

    MODIFY ( SERVICE_OBJECTIVE = ELASTIC_POOL ( name = pool1 ) ) ;  
    0 comments No comments