Thursday, February 16, 2012

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.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.

No comments:

Post a Comment