Often, users are reporting point in time restores are showing recent(current) data in the restored server.
Solution: When you run point in time restore (PITR) this operation will create a new server and restore your server to a point of time that you choose. When the restore operation is successful please remember that you need to update the connection string to connect to the newly created server in two places, server name and username.
It's important to change the username in the new connection string to reflect the new server name. In Azure Database for MySQL and Azure Database for PostgreSQL usernames consists of two parts separated by the '@' symbol in the following format: username@servername.
Now why this happens?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.