How do I increase the max database size of an individual database within an elastic pool?

Ben,

  Increasing the max database size for a database in elastic pool is no different from increasing the size for a stand-alone SQL database. You can use the t-sql command 'Alter Database..' to increase the size upto the maximum allowable limit for the database (for e.g. 250 GB for a database in a standard elastic pool).

ALTER DATABASE MyDatabase MODIFY (MAXSIZE=100GB)

But also keep in mind that total actual size allowed for all databases together in your elastic pool is limited by your elastic pool size settings (for e.g. for a standard elastic pool the size allowances are 1GB for every eDTU provisioned for the pool. i.e. a 200 eDTU standard pool allows up to 200 GB of actual storage for all the databases in that pool together). Details are provided at the SQL Database pricing page here

-- Srini

• Proposed as answer by Joseph IdziorekMicrosoft employee 15 hours 23 minutes ago

Ben,

  Increasing the max database size for a database in elastic pool is no different from increasing the size for a stand-alone SQL database. You can use the t-sql command 'Alter Database..' to increase the size upto the maximum allowable limit for the database (for e.g. 250 GB for a database in a standard elastic pool).

ALTER DATABASE MyDatabase MODIFY (MAXSIZE=100GB)

But also keep in mind that total actual size allowed for all databases together in your elastic pool is limited by your elastic pool size settings (for e.g. for a standard elastic pool the size allowances are 1GB for every eDTU provisioned for the pool. i.e. a 200 eDTU standard pool allows up to 200 GB of actual storage for all the databases in that pool together). Details are provided at the SQL Database pricing page here

-- Srini

• Proposed as answer by Joseph IdziorekMicrosoft employee 15 hours 12 minutes ago

Ben,

  Increasing the max database size for a database in elastic pool is no different from increasing the size for a stand-alone SQL database. You can use the t-sql command 'Alter Database..' to increase the size upto the maximum allowable limit for the database (for e.g. 250 GB for a database in a standard elastic pool).

ALTER DATABASE MyDatabase MODIFY (MAXSIZE=100GB)

But also keep in mind that total actual size allowed for all databases together in your elastic pool is limited by your elastic pool size settings (for e.g. for a standard elastic pool the size allowances are 1GB for every eDTU provisioned for the pool. i.e. a 200 eDTU standard pool allows up to 200 GB of actual storage for all the databases in that pool together). Details are provided at the SQL Database pricing page here

-- Srini

• Proposed as answer by Joseph IdziorekMicrosoft employee Wednesday, September 02, 2015 3:56 PM

Ben,

  Increasing the max database size for a database in elastic pool is no different from increasing the size for a stand-alone SQL database. You can use the t-sql command 'Alter Database..' to increase the size upto the maximum allowable limit for the database (for e.g. 250 GB for a database in a standard elastic pool).

ALTER DATABASE MyDatabase MODIFY (MAXSIZE=100GB)

But also keep in mind that total actual size allowed for all databases together in your elastic pool is limited by your elastic pool size settings (for e.g. for a standard elastic pool the size allowances are 1GB for every eDTU provisioned for the pool. i.e. a 200 eDTU standard pool allows up to 200 GB of actual storage for all the databases in that pool together). Details are provided at the SQL Database pricing page here

-- Srini

• Proposed as answer by Joseph IdziorekMicrosoft employee Wednesday, September 02, 2015 3:56 PM
• Marked as answer by Casey KarstMicrosoft employee, Moderator 15 hours 33 minutes ago

Ben,

  Increasing the max database size for a database in elastic pool is no different from increasing the size for a stand-alone SQL database. You can use the t-sql command 'Alter Database..' to increase the size upto the maximum allowable limit for the database (for e.g. 250 GB for a database in a standard elastic pool).

ALTER DATABASE MyDatabase MODIFY (MAXSIZE=100GB)

But also keep in mind that total actual size allowed for all databases together in your elastic pool is limited by your elastic pool size settings (for e.g. for a standard elastic pool the size allowances are 1GB for every eDTU provisioned for the pool. i.e. a 200 eDTU standard pool allows up to 200 GB of actual storage for all the databases in that pool together). Details are provided at the SQL Database pricing page here

-- Srini

• Proposed as answer by Joseph IdziorekMicrosoft employee Wednesday, September 02, 2015 3:56 PM
• Marked as answer by Casey KarstMicrosoft employee, Moderator Wednesday, September 09, 2015 3:33 PM

Ben,

  Increasing the max database size for a database in elastic pool is no different from increasing the size for a stand-alone SQL database. You can use the t-sql command 'Alter Database..' to increase the size upto the maximum allowable limit for the database (for e.g. 250 GB for a database in a standard elastic pool).

ALTER DATABASE MyDatabase MODIFY (MAXSIZE=100GB)

But also keep in mind that total actual size allowed for all databases together in your elastic pool is limited by your elastic pool size settings (for e.g. for a standard elastic pool the size allowances are 1GB for every eDTU provisioned for the pool. i.e. a 200 eDTU standard pool allows up to 200 GB of actual storage for all the databases in that pool together). Details are provided at the SQL Database pricing page here

-- Srini

• Proposed as answer by Joseph IdziorekMicrosoft employee Wednesday, September 02, 2015 3:56 PM
• Marked as answer by Casey KarstMicrosoft employee, Moderator Wednesday, September 09, 2015 3:33 PM

Ben,

  Increasing the max database size for a database in elastic pool is no different from increasing the size for a stand-alone SQL database. You can use the t-sql command 'Alter Database..' to increase the size upto the maximum allowable limit for the database (for e.g. 250 GB for a database in a standard elastic pool).

ALTER DATABASE MyDatabase MODIFY (MAXSIZE=100GB)

But also keep in mind that total actual size allowed for all databases together in your elastic pool is limited by your elastic pool size settings (for e.g. for a standard elastic pool the size allowances are 1GB for every eDTU provisioned for the pool. i.e. a 200 eDTU standard pool allows up to 200 GB of actual storage for all the databases in that pool together). Details are provided at the SQL Database pricing page here

-- Srini

• Proposed as answer by Joseph IdziorekMicrosoft employee Wednesday, September 02, 2015 3:56 PM
• Marked as answer by Casey KarstMicrosoft employee, Moderator Wednesday, September 09, 2015 3:33 PM