SQL Server中数据库数据的存档/快照 [英] Archiving/Snapshot of database data in SQL Server

问题描述

我正在寻找一种功能，我可以在数据库中拍摄快照或存档特定的数据集，每当需要回到存档状态时，我该怎么办？实现这个？为了更清楚地了解需要，下面是详细示例。



我有一个生产服务器和测试服务器，我在测试中对我的应用程序进行了一些设置/配置服务器并更新了生产服务器。在更新生产服务器之前，我应该对正在更新的数据进行存档/快照，这样如果在更新时出现问题，我应该能够回到生产服务器中先前的数据状态。



先谢谢。

Hi,
I am looking for a functionality where I can take a snapshot or archive the specific set of data in database and whenever requried I need to go back to the archived state, how can I achieve this ? for more clarity on the need, below is the detail example.

I have a production server and test server, I have made some settings/configuration to my application in test server and updated the production server. Before updating the production server, I should archive/snapshot the data that is being updated, so that if something goes wrong in updating I should be able to go back to the previous state of data in production server.

Thanks in Advance.

推荐答案

在做任何破坏性的事情之前，请先备份你的数据库，看这里使用快照：http://blog.sqlauthority.com/2010 / 04/05 / sql-server-2008-introduction-to-snapshot-database-restore-from-snapshot / [ ^ ]

Always backup your database first before doing anything destructive, see here for using snapshots : http://blog.sqlauthority.com/2010/04/05/sql-server-2008-introduction-to-snapshot-database-restore-from-snapshot/[^]

这篇关于SQL Server中数据库数据的存档/快照的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！