backup with users  
Author Message
Theuns





PostPosted: Sat Aug 16 07:55:03 CDT 2003 Top

SQL Server >> backup with users

Hi
one small question/
i need to take backup of one database from one server and
restore it to another server/destination. db may be same
or difft,but i need to do this so that all usernames
belonging to that particular db should also be transferred
to new db on other server.

how can we restore db with same users/login which belong
to source server/database.

SQL Server26  
 
 
yihyoonl





PostPosted: Sat Aug 16 07:55:03 CDT 2003 Top

SQL Server >> backup with users Hi Sanjay,

Take a look at this article, see if this is what you are looking for.

HOW TO: Transfer Logins and Passwords Between Instances of SQL Server ID:
246133.KB.EN-US
http://support.microsoft.com/?id=246133

Or you can use sp_change_users_login.

Sincerely,
Yih-Yoon Lee [Microsoft]
Microsoft SQL Server Support

This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.