Azure has an in built point-in0-timne back up the can be configured to 30 days (it comes out of the box set to 7 days).
Depending upon your willingness to rely on Microsoft to keep backups, it may be worth considering exporting a bacpac periodically.
Here are two methods to export data to a bacpac (the conventional format for keeping a database definition and the data):
- Run a script as follows to extract a bacpac as a snapshot to a local drive
sqlpackage.exe /a:Export /SourceConnectionString:"Server=tcp:CLIENTID.database.windows.net,1433;Initial Catalog=insol6_CLID;Persist Security Info=False;User ID=sysadmin;Password=18ChrComplexPA$$xx;MultipleActiveResultSets=True;Encrypt=True;TrustServerCertificate=True;Connection Timeout=60;" /tf:C:\SQLBACKUP\insol6_CLID.bacpac /p:TargetEngineVersion=Latest - Install Microsoft Data Studio and follow the export wizard
Some options and issues discussed here:
https://techcommunity.microsoft.com/t5/azure-database-support-blog/export-azure-sql-database-advanced-scenarios/ba-p/3125132
Comments
0 comments
Please sign in to leave a comment.