question

DiogoBuenodaSilva-8224 avatar image
1 Vote"
DiogoBuenodaSilva-8224 asked OuryBa-MSFT commented

SQL Server(Azure Cloud) - Maximum storage size

Hello,
in my company we use the sql server azure cloud, and we are almost reaching the maximum data size. We want to separate some existing data in the database, as it is already old, but we don't want to delete them, just separate to reduce space and improve performance. In this case, what is indicated to do and how to do it?
Thanks.

azure-sql-database
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AlbertoMorillo avatar image
0 Votes"
AlbertoMorillo answered OuryBa-MSFT commented

You may want to consider move that data to new Azure SQL Database and consider using Elastic Queries if you need to query recent data (actual database) and old data (new database with old data.

You may also consider implementing sharding. Here is how to move data between databases.



· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @DiogoBuenodaSilva-8224 Please see @AlbertoMorillo's answer and let us know if you have additional queries.

Regards,
Oury

0 Votes 0 ·