Forum Discussion
Snapshot of Access Web Database for Legal purposes
I created a step by step instruction for you to connect to your database using SQL Server management studio as Frank suggested.
You can also find these instructions (and others) on our support site using your Office 365 credentials to sign into our support site.
https://dpsupportweb20160618054131.azurewebsites.net/QuickReferenceGuides
You can use the APP files to back up your Access Web App to a file. However, you can only use the App files to restore the data in the originating environment. i.e. SQL Server online
"You can only install and reuse Access app packages across the same deployment environment. Installing Access app packages from on-premise SharePoint installations into Office 365 or SharePoint Online are not supported scenarios. For example, if you’ve created your Access app package in a SharePoint site that your organization hosts separately from Office 365 or SharePoint Online, you can’t install that app package in Office 365 or SharePoint Online. The same restriction is in place when trying to install Access app packages created from Office 365 or SharePoint Online into on-premise SharePoint installations."
Greg,
content of an Access Web App is stored in a SQL Azure database. You can use SQL Server DBA tools to connect and create snapshots. You can also sync SQL Azure content with other sources using commercial sync tools, e.g. the Layer2 Cloud Connector.
Hope that helps, Thanks, Frank.
Thanks for your reply Frank. I hope the request to make a snapshot of access web app content is not a frequent request.