I have a database with 300 users I want to restore this database to development server. How can I restore the database so that all the users and permissions can be preserved on destination server. It is SQL Server 2005 database.
The database will restore with user permission. however logins are not part of a backup or restore. You can script them with sp_help_revlogin (from MS) and run the resulting script on the development server to setup the logins.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply