SQL Server数据存档解决方案 [英] SQL Server Data Archive Solution
问题描述
我正在寻找一种解决方案来存档数据库中存在的数据.我的数据库是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/
但此解决方案尚不清楚
我不知道在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.
例如，您需要考虑:
-
要归档哪些数据?
例如所有数据或较旧的数据 比某个日期?
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数据存档解决方案的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
