"Invalid source server id provided"Getting this error when restoring mysql database from recent deleted mysql database

Question

"Invalid source server id provided"Getting this error when restoring mysql database from recent deleted mysql database

Popkornfintech Popkornfintech 5

Invalid source server id provided. The source server should be an existing server which belongs to same subscription and region as the target server

Oury Ba-MSFT 20,931 Reputation points Microsoft Employee Moderator

2023-06-05T18:03:13.5333333+00:00

@Popkornfintech Popkornfintech Thank you for reaching out.

My understanding is that you are facing an issue while restoring a MySQL database from a recent delete.

When was the server deleted?

Regards,

Oury

adminhotel 0

Yo quiero recuperar una base de datos y me esta regresando un 400 con este codigo de error ,como podria saber la region de la base

{
  "error": {
    "code": "InvalidSourceServerId",
    "message": "Invalid source server id provided. The source server should be an existing server which belongs to same subscription and region as the target server."
  }
}

adminhotel 0 Reputation points

2023-11-28T01:35:34.0533333+00:00

La eliminacion lleva apenas 7 horas

2 answers

Your answer

Oury Ba-MSFT 20,931 Reputation points Microsoft Employee Moderator

2023-06-05T18:03:13.5333333+00:00

@Popkornfintech Popkornfintech Thank you for reaching out.

My understanding is that you are facing an issue while restoring a MySQL database from a recent delete.

When was the server deleted?

Regards,

Oury
adminhotel 0 Reputation points

2023-11-27T23:52:01.8366667+00:00

Yo quiero recuperar una base de datos y me esta regresando un 400 con este codigo de error ,como podria saber la region de la base

{ "error": { "code": "InvalidSourceServerId", "message": "Invalid source server id provided. The source server should be an existing server which belongs to same subscription and region as the target server." } }
adminhotel 0 Reputation points

2023-11-28T01:35:34.0533333+00:00

La eliminacion lleva apenas 7 horas

Answer 1

Oury Ba-MSFT 20,931 Microsoft Employee Moderator

@Popkornfintech Popkornfintech See my answer below.

If the server was deleted within 5 days, then it will be possible to restore. But if it passed 5 days then the only way will be to create a support ticket. We don't store the backups after 5 days. The reason we ask to open a support ticket is by chance if the backup deletion job has not run yet, we may be able to locate the backup and help restore but it is best effort and no guarantees. We only retain backup for 5 days after server deletion so we cannot provide an API for restoring beyond 5 days as backup file may not exist.

Restore a deleted Azure Database for MySQL - Flexible Server

Regards,

Oury

Oury Ba-MSFT 20,931 Reputation points Microsoft Employee Moderator

2023-06-06T19:26:26.31+00:00

@Oury Ba-MSFT

Checking if the above answer was helpful. If that does not resolve your issue, please do comment below and we can keep working on the same.

Regards,

Oury

Answer 2

RahulRandive 10,486 Volunteer Moderator

Hi @Popkornfintech Popkornfintech

This thread seems to be duplicate of https://learn.microsoft.com/en-us/answers/questions/1444649/recuperar-servidor-de-base-de-datos-mysql-flexible.

Thank you!

Share via

"Invalid source server id provided"Getting this error when restoring mysql database from recent deleted mysql database

2 answers

Your answer