修改表上的备份数据库 [英] Backup databases on modified table

问题描述

我有一些数据库需要备份，我不想全部备份.无论更新了哪个表或修改了那些数据库，我都只想备份.请建议我如何使用查询或其他技术.提前致谢. :cool:

Hi,

I have some databases to take backup, I don''t want to take all. Whichever the table got updated or modified those databases only I want to take the backup. Please suggest me how to take using query or using other technology. Thanks in advance. :cool:

推荐答案

最简单的方法是对事务日志进行增量备份.因此，您将创建一个完整备份(每周说一次)，然后再创建事务日志备份，您可以安排每xx分钟安排一次.

The easiest way is taking incremental backup of transactional log. So you will create a full backup (lets say once a week) and thereafter transactional log backup, which you can schedule each xx minutes.

您可以对每个数据库使用查询.

You could use the query for each database.

SELECT
        [name]
       ,create_date
       ,modify_date
FROM
        sys.tables

或定义修改的时间范围，

or perhaps define modified time frame,

SELECT
        [name]
       ,create_date
       ,modify_date
FROM
        sys.tables
WHERE
        modify_date > DATEADD(day,-30,GETDATE())

并获取已在预期范围之间修改日期的数据库备份.

如果有帮助，请 投票 和 接受答案 .

And take the Backup of the DB which have modified date between expected range.

Please vote and Accept Answer if it Helped.

这篇关于修改表上的备份数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！