SQL Server 2005 仅恢复一种架构
我很确定这是不可能的......
我们有一个包含多个模式的数据库。 每个模式属于不同的用户。 一位用户问“如果我发现我犯了一大堆错误，是否可以恢复到我的数据昨天的状态”。 显然我们可以恢复整个数据库，但这也会恢复我们不想做的其他模式......
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....
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
您是对的，不可能仅恢复单个架构。
也就是说，如果您将所有特定架构对象存储到特定文件组并且一直在进行文件组备份，那么您可以仅恢复受影响的文件组。
但是，如果您正在管理大量架构/文件组，这将非常麻烦。
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.
将整个数据库恢复到具有不同名称的数据库。
复制您要恢复的部分。
Restore the whole database to a database with a different name.
Copy over the parts that you wish to restore.
您必须将整个数据库的副本还原到某个时间点 然后将架构数据复制回原始数据库。 如果将来需要定期执行此操作，您可以按照 John 建议使用文件组并执行 部分恢复副本，然后将数据复制回。但是，即使使用文件组，您也无法部分恢复到某个时间点（这就是您所要做的）要求），据我所知，不存在这样的事情。
You have to restore a copy of the whole database to a point in time and then copy over the schema data back into the original database. If this is needed on a regular basis in future you could use filegroups as John suggested and do a partial recovery of a copy, then copy the data back in. But you cannot, even with filegroups, do a partial recovery to a point in time (which is what you're asking for), afaik no such thing exists.