Share via

Failed deploy data base from ssms to azure sql

Amir Ariely 1 Reputation point
2020-10-12T06:16:10.293+00:00

Hi, while trying to upload from an on premise sql server manager studio to azure sql database I encountered an error and the operation failed.
I am using the latest ssms (v.18), in addition in my azure database I have a maximum storage size of 500 GB.

pictures and error msgs attached below.

Thanks a lot in advance,
Amir

31537-image.png

31520-image.png

Azure Backup
Azure Backup
An Azure backup service that provides built-in management at scale.
1,282 questions
Azure Database Migration service
Azure SQL Database
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,977 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 112.7K Reputation points MVP
    2020-10-12T21:41:09.673+00:00

    The error message speaks for itself. You cannot cram a 500 GB database into Basic Edition which has an upper limit of 2 GB. You cannot even do Standard, where the upper limit is 250. The wizard seems to think that you need 550 GB, so you will need at least a P1. Or go for a General Purpose; that may be a better deal than P1., but I don't know.

    1 person found this answer helpful.
    0 comments
  2. m 4,271 Reputation points
    2020-10-12T07:42:03.697+00:00

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.