如何备份一段时间的SQL数据库 [英] how to backup SQL database of a time period

问题描述

有没有办法只备份今天的SQL数据库或只备份日期而不是完全备份？

Is there any way to backup SQL Database of today only or of between dates only instead of full backup ??

推荐答案

没有开箱即用的东西什么能使你。你可以得到的最接近的是进行时间点恢复。

No there is nothing out of the box what will enable you. The closest you can get is do a Point in Time recovery.

sys.dm_exec_requests

DMV有一些列可以是有助于预测数据库在备份中花费的时间。

DMV has some columns that can be helpful in predicting how much time a database will take in its backup.

这篇关于如何备份一段时间的SQL数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！