SQL Server 2005 仅还原一个架构 [英] SQL Server 2005 restore one schema only

问题描述

我很确定这是不可能的....

I am pretty sure this isn't possible....

我们有一个包含多个模式的数据库.每个模式属于不同的用户.一位用户问如果我发现我犯了一大堆错误，是否有可能恢复到我的数据昨天的状态".显然我们可以恢复整个数据库，但这也会恢复我们不想做的其他模式......

We have a database with several schemas. Each schema belongs to a different user. One user was asking "if I find out I made a whole load of errors would it be possible to revert to the state my data was in yesterday". Obviously we could restore the whole database, but that would restore the other schemas as well which we do not want to do....

推荐答案

您说得对，仅恢复单个架构是不可能的.

You are correct, it is not possible to restore a single schema only.

也就是说，如果您将所有特定架构对象存储到特定文件组并进行文件组备份，那么您可以只恢复受影响的文件组.

That said, had you stored all specific schema objects to a specific Filegroup and had been taking Filegroup backups then you could restore just the affected Filegroup.

但是，如果您要管理大量架构/文件组，这将非常麻烦.

If you are administering a large number of schemas/filegroups however, this would be quite cumbersome.

这篇关于SQL Server 2005 仅还原一个架构的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！