数据库备份系统 [英] Database Backup System

问题描述

如何使用From和To日期对数据库备份某段时间

How to take database backup certain period using From and To date

推荐答案

根据定义，数据库备份整个数据库备份。如您所述，您希望存档部分数据。一种非常简单的方法是使用必要的模式创建归档数据库， SELECT INTO [ ^ ]从实时数据库到存档数据库，必要时从实时删除，备份存档数据库，甚至删除它必要。这可以根据所选的备份/归档策略进行优化。

Database backup is by definition whole database backup. As you stated, you want to archive partial data. A really simple way is to create an "Archive" database with the necessary schema, SELECT INTO[^] from the live database to the archive database, delete from live if necessary, backup the archive database, and even drop it if necessary. This can be refined based on the chosen backup/archive strategy.

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