This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 7.000000000000001%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
Such a simple question, but answers thru chat are complex, circular and not helpful. I simply would like to know if my database is being backed up, how often and how I can restore in case of issues. Please do not refer me to circular documentation, this should be a simple question and answer like yes\no, every 10 days and right click on this object to run restore. My database is on a paid subscription in Azure and I work with it using MSSIS
thank you
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 52%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
As Olaf mentioned, this is the way to check backup and restore events.
As we can see that the "Backup and Restore Events" option is not available in your SQL Server Management Studio (SSMS) context menu. Let's try another approach to check if your Azure SQL database is being backed up and how to restore it.
1.Check Backup Status:
Azure SQL databases are automatically backed up. You can verify this by checking the backup history using the Azure portal.
Navigate to your Azure SQL database in the Azure portal.
Go to the "Backups" section under "Operations" to see the backup history and retention period.
2.Restore Database:
To restore your database, follow these steps:
In the Azure portal, go to your SQL database.
Select "Restore" from the toolbar.
Choose the point in time you want to restore to and follow the prompts to complete the restore process.
3.Is my SQL database being backed up?
YES
Backup frequency
Azure SQL Database creates:
Full Backups every week.
Differential Backups every 12 or 24 hours.
Transaction log backups approximately every 10 minutes.
I hope this information helps. Please do let us know if you have any further queries.
If the comment is helpful, please click "Upvote it".
In SSMS do a right-mouse click on the database in mind => "Reports" = "Standartreports" = "Backup and Restore Events".
Additional see Quickstart: Backup and restore a SQL Server database with SSMS
thanks you, but you can see that option is not available to me per attached screenshot
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
thanks I saw this too, just couldn't find anything in the MSSIS UI or or Azure SQL UI that gives me an answer, is my database being backed up, where and how often. I guess I should just trust the documentation then, like the user manual for car :)
As database is never successfully backed up until you test the restore. You should create a new instance and restore.
finally found what I was looking for..
issue resolved