Azure PostgreSQL Lesson Learned #10: Why PITR Networking Rules Matter
Co‑authored with angesalsaa Symptoms Customer attempted to restore a server configured with public access into a private virtual network. Restore operation failed with an error indicating unsupported configuration. Root Cause Azure enforces strict networking rules during PITR to maintain security and consistency: Public access servers can only be restored to public access. Private access servers can be restored to the same virtual network or a different virtual network, but not to public access. Why This Happens Networking mode is tied to the original server configuration. Mixing public and private access during restore could expose sensitive data or break connectivity assumptions. Contributing Factors Customer assumed PITR could switch networking modes. No prior review of Azure documentation on restore limitations. Specific Conditions We Observed Source server: Private access with VNet integration. Target restore: Attempted to switch to public access. Operational Checks Before initiating PITR: Confirm the source server’s networking mode (Public vs Private). Review restore options in the Azure portal → Restore. Mitigation Goal: Align restore strategy with networking rules. If source is Public: Restore only to Public access. If source is Private: Restore to same or different VNet (within the same region). Post-Resolution Customer successfully restored to a different VNet after adjusting expectations. Prevention & Best Practices Document networking mode for all PostgreSQL servers. Train teams on PITR limitations before disaster recovery drills. Avoid assumptions always check official guidance. Why This Matters Ignoring these rules can delay recovery during critical incidents. Knowing the constraints upfront ensures faster restores and compliance with security policies. Key Takeaways Issue: PITR does not allow switching between Public and Private access. Fix: Restore within the same networking category as the source server. References Backup and Restore in Azure Database for PostgreSQL Flexible ServerPreventing and recovering from accidental deletion of an Azure Database for MySQL flexible server
Accidental deletion of critical Azure resources, such as Azure Database for MySQL flexible servers, can disrupt operations. To help avoid such accidental deletions, you can use a couple of options, including Azure Resource Locks and Azure Policy. This post explains how to implement these mechanisms, and how to revive a dropped MySQL flexible server by using the Azure CLI.
Is it possible to restore a folder to a previous state?
Is there a way to restore a folder to its previous state? For example its state as at one week ago? I see this is possible for individual files, but not for folders. (Maybe the solution is to delete the folder and then look for a version in the onedrive recycle bin - will this work?)
Shared ToDo deleted tasks > how to restore?
Hello everyone, We share a ToDo with my colleagues and I deleted some tasks by mistake. I tried to restore them but whitout success. I cannot find any place where those deleted items went. I tried a lot a of solutions found on the net but none of them worked. I also point out that those tasks were not mine. So I am looking for some help. Does anyone have an idea or even a solution about that?
Active Directory Backup & Restore issue
Hi, I have taken backup of my operational Active Directory server and tried to restore it to different machine. My server is up and able to access Active Directory users and computer console. when i am trying to create new user, it is giving me below error. Source and Destination server has same platform. Anyone has idea ?
Microsoft 365 Archive Public Preview?
Hi all, Has anyone heard from Microsoft on the timeline for the public preview for M365 Archive? We're reviewing similar solutions from AvePoint but our interest in a native archiving tool is also very high, but we do have project deadlines to meet - hence my interest in double checking when this should be available for customers who have expressed interest earlier this year through the Syntex "register for more info" form?No option for restoring files from Bin
Hi, so I have accidentally removed the OneDrive folder on my PC, therefore went to the website and to the Bin to restore, however I do not have the restore option when right-clicking the files. Only Remove. I did have my account frozen and therefore have purchased additional data, it says 0/100GB used yet still claims y account is frozen, is that why I cannot Retore my files? I tried the chatbot, no help on the matter, can't seem to be able to find a contact to technical support, all the clicks just send me away in the wrong places. I have literally lost most of my files as my Desktop and Documents folders are now gone. Please help.
