如何使用sqlpackage对Azure SQL DB进行增量备份
我创建了一个DevOps Pipeline，该管道使用SQLPackage执行任务，该sqlpackage在.bacpac文件中备份我们的SQL db。该出口花费了将近5个小时才能完成。每天晚上我们要进行生产数据库备份时，我们只想进行增量DB备份而不是完整的备份。
您能否指导我使用sqlpackage或建议其他一些选择
，谢谢 萨钦
I have created a devOps pipeline which executes a task using SQLPackage which takes the backup of our SQL DB in .bacpac file. This export took almost 5 hours to complete. As we are going to take the Production DB backup every night, we want to take only incremental DB backup instead of Full Backup.
Can you please guide me how we can do that using SQLPackage or suggest some other options
Thanks,
Sachin
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
Azure SQL数据库支持完整的备份，差速器备份和事务日志备份。
差异备份： -
它基于最新的完整数据备份。它仅收集在上次完整数据备份之后更改的数据。您可以定期备份数据库，而无需体验完整数据库备份的负担。Azure SQL数据库提供自动备份 。
参考： -
https://learn.microsoft.com/en-us/azure/azure-sql/database/automated-backups-overview?view=Azuresql＆amp; tabs = single-database
Azure SQL Database supports Full backup, Differential backup and Transaction log backup.
Differential backup: -
It is based on the latest full data backup. it only collects the data which are changed after the last full data backup. You may routinely backup your database without experiencing the burden of complete database backups.Azure SQL Database provides automated backups.
Reference: -
https://learn.microsoft.com/en-us/azure/azure-sql/database/automated-backups-overview?view=azuresql&tabs=single-database