Share via

Can you increase the size of a PaaS sql after it is created? (i.e. P4 change size to P6)

David Kim 66 Reputation points
2020-08-17T14:48:04.06+00:00

Can you increase the size of a PaaS sql after it is created? (i.e. P4 change size to P6)? Can we downgrade the size from P6 to P4?

Wondering if you downgrade from P6 (4 TB) to P4 (500 Gb) that if your database might be impacted?

And is the maximum storage still 4 TB of the PaaS database with only one database allowed with PaaS SQL?,... just confirming.

Does SQL PaaS have any HA ability like a SQL AG with two nodes?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,187 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Cris Zhan-MSFT 6,611 Reputation points
    2020-08-18T09:12:26.293+00:00

    Hi DavidKim-4125,

    Azure SQL Database is a fully managed platform as a service (PaaS) database engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement. you can read this MS document to get some useful information.

    Because your issue is related to Azure SQL database, I suggest you open a thread in Azure SQL database forum, People there will help you more effectively.

    Hope this could help you.
    Best regards,
    Cris

    ===============================================

    If the response helped, do "Accept Answer" and upvote it.