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.
A:
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.
Andomar
2009-08-20 19:54:13
how to you restore as dbo?
mrblah
2009-08-20 20:38:59
Select "Restrict access to the restored database (WITH RESTRICTED_USER)" on the options tab
Andomar
2009-08-20 22:17:10
A:
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?
Remus Rusanu
2009-08-20 21:14:41