在sql server中备份和恢复单个文件组 [英] Backup and restore of single file group in sql server

问题描述

大家好，



我创建了一个数据库，它包含156个文件组。我想要为单个文件组备份并恢复文件组（具有相同数据库的其他服务器）中的文件组，而不是进行完全备份。是否可能？





错误： - 提供的备份与数据库不在同一个恢复路径上，并且没有资格用于在线文件恢复。



检查： - 我检查了两个数据库恢复模型，LPN，逻辑名称，文件组，校对名称都相同。

Hi All,

I created a database and it contains 156 file groups. Instead of taking full backup, i want to take backup for the single file group and restore file groups in the file group(other server with same database). Is it possible?


Error :- The supplied backup is not on the same recovery path as the database, and is ineligible for use for an online file restore.

Checking:- i checked two database recovery model,LPN,logical name, file group, collation name all are same.

推荐答案

这可以解决你的问题：

SQL Server Central：在辅助数据库上备份文件组和还原 [ ^ ]



这是一篇旧帖子，用SQL Server 2005标记，但据我所知，这一点自那以后没有改变。



文件组因性能和可扩展性原因而有用，它们不是备份数据库相关部分的意思以独立的方式。如果您已达到此要求，则可能出于错误的原因使用了文件组。



如果您有另一台具有相同数据库的服务器，则应使用现有的同步方式。



使用备份进行灾难恢复，并使用同步技术同步服务器。不要试图用前者代替后者。



希望这会有所帮助。干得好:)：

This can sched a light on your question:
SQL Server Central: Backup FileGroup and Restore on Secondary Database[^]

This is an old post, tagged with SQL Server 2005, but as far as I know this has not changed since.

Filegroups are useful for performance and scalability reasons, they are not a mean to backup dependant parts of your database in an independent way. If you have come to this requirement, you may have used filegroups for wrong reasons.

If you have another server with the same database, you should use existing way of synchronization.

Use backups for disaster recoveries, and use synchronization techniques to synchronize your servers. Don't try to use the former in place of the latter.

Hope this helps. Good work :)

这篇关于在sql server中备份和恢复单个文件组的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！