SQL Server 数据存档解决方案

问题描述

我正在寻找一种解决方案来存档我的数据库中存在的数据.我的数据库是 SQL Server 2008，大约有 250 个表.我在网上搜索并找到以下链接:http://www.dbazine.com/sql/sql-articles/charran13/

I'm looking for a solution to archive data that exists in my database. My database is SQL Server 2008 and have approximately 250 tables. I search web and find the below link : http://www.dbazine.com/sql/sql-articles/charran13/

但是这个解决方案不清楚

but this solution is not clear

我不知道在 sql server 中有没有直接的方法可以做到这一点.请给我一个解决方案.

I don't know that is there a direct way for doing this in sql server. please give me a solution.

推荐答案

您选择推出的解决方案将取决于您实施数据归档的原因.

The solution that you choose to rollout will be dependent on your reasons for implementing data archival.

例如，您需要考虑:

1. 要归档哪些数据?

例如所有数据或旧数据超过某个日期?

For example all data or data older than a certain date?

这对大多数人都有影响合适的归档技术使用，即是否是完整的数据库备份就足够了专门构建的归档过程使用 SQL Server 集成服务可能更合适.

This has implications for the most suitable archive techniques to be used, i.e. whether a full database backup could suffice or perhaps a purpose built archiving process using SQL Server Integration Services may be more suitable.

归档数据需要具有多大的可访问性?

归档数据是否需要立即可用，也许在较慢的 SATA 存储，或者可能是几天的时间来获得访问数据是否可以接受?也许如果恢复时间很长自由然后一个完整的数据库备份，定期服用，说一次一个月就够了.如果在另一方面，数据需要非常手头有很多，然后是解决方案.

Does the archived data need to be immediately available, perhaps on slower SATA storage or perhaps a period of several days to acquire access to the data is acceptable? Perhaps if the restore time is quite liberal then a FULL database backup, taken at regular intervals, say once a month could suffice. If on the other hand the data needs to be very much on hand then a solution.

数据要求的安全含义是什么?

例如，备份应该是加密或是否正在存储数据异地是否有足够的体力安全到位?

For example, should backups be encrypted or if data is being stored offsite is there adequate physical security in place?

也许如果您能提供更多关于您希望存档数据的原因以及希望存档多少数据的详细信息，那么我们或许可以提供更具体的指导.

Perhaps if you could provide some more details as to your reasons for wishing to archive your data and also how much of your data you wish to archive, then we may be able to provide more specific guidance.

这篇关于SQL Server 数据存档解决方案的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持html5模板网！