归档sql server数据库 [英] archive sql server database

问题描述

我在SQL Server 2014中有一个数据库，想要将其存档并删除原始数据库数据并导入新数据，我想恢复存档只是为了查看dta，我希望每3个月获得一次数据（以上解释的程序）。在vb net中有可能吗？

I have a database in SQL Server 2014 and want to archive it and delete the original database data and import NEW data and I want to "restore" the archive just to view the dta, I want arcive the data every 3 month (the above explained procedure). In vb net is it possible?

推荐答案

首先，我不确定归档是最好的解决方案。可行性取决于你为什么要这样做。如果是因为性能原因，我强烈建议搜索其他替代方案并优化数据库及其用法。



归档有什么选择。你可以：

• 使用复制将数据复制到别处
• 分离数据库，在别处复制并重新附加，分离的数据库可以用作单独的数据库。
• 使用SSIS创建数据复制作业等。

First of all I'm not sure that archiving is the best solution. The feasibility depends on why you're doing this. If it's because of performance reasons, I would strongly suggest searching other alternatives and optimizing the database and it's usage.

What comes to archiving, you have multiple choices. You can:

• copy the data elsewhere using replication
• detach the database, make a copy elsewhere and reattach, the detached database can be used as a separate database.
• use SSIS to create data copy jobs etc

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