在SQL Server 2008中恢复数据库时，如何忽略用户？
我正在将 SQL Server 2000 数据库导入到 SQL Server 2008 服务器。
我不想导入任何用户/权限信息，有没有办法忽略它？
当前的恢复给我带来了问题，因为它有用户绑定到数据库。
I am importing a SQL Server 2000 database to my SQL Server 2008 server.
I don't want to import any user/permission information, is there a way to ignore this?
The current restoration is causing me issues as it has users tied to the db.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
恢复包括用户和权限。您可以在“仅 dbo”模式下恢复数据库，这样您就有时间在数据库重新联机之前删除所有用户。
A restore includes users and permissions. You could restore the database in "dbo only" mode, which would give you time to remove all users before the database came back online.
恢复操作是物理操作，它恢复数据页。它确实对页面的含义一无所知。事实证明，某些页面属于存储有关用户和权限信息的目录视图。绝对没有办法只恢复数据库的“部分”，就像忽略某些目录视图一样。
您能否详细说明恢复后用户遇到的“问题”是什么？
The restore operation is a physical operation, it restores data pages. It really knows absolutely nothing about the meaning the pages. As it turns out, some of the pages belong to catalog views that store information about users and permissions. There is absolutely no way to restore only 'part' of the database, as in to ignore certain catalog views.
Can you detail exactly what are the 'issues' you encounter with the users after the restore?