Error creating Azure SQL Database

A quick post today, quite simply, the error message is:

“code”: “ConflictingDatabaseOperation”,  “message”: “Operation on server x and database y is in progress.  Please wait a few minutes before trying again.”

What is going on here? Well for this example (and maybe yours) I created a database called X then I decided to abort the operation within couple of seconds because I missed some important configuration setup. Then I was very quick to initiate a new create request with the same database name called X.

This caused a conflict because the server still registered the first database creation name. So, the morale of the story here? If you have deleted a database wait for the success message to appear before you start creating it again.

Just click on that redeploy option as shown below.

1 thought on “Error creating Azure SQL Database

  1. Pingback: Dew Drop – April 12, 2021 (#3421) – Morning Dew by Alvin Ashcraft

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s