Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

backup and restore users and logins Expand / Collapse
Author
Message
Posted Friday, August 1, 2014 1:02 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, September 3, 2014 5:40 AM
Points: 80, Visits: 343
We are moving a database from a SQL Server 2005 instance to a SQL Server 2008 R2 instance.

Is there a way to backup the SQL Server logins associated with the users in the database and avoid having to manually recreate the logins and address the orphan users?

The DBA for the destination server alluded to a stored procedure for doing this, but I'm not finding it with a Google search...

Thanks!
Post #1598800
Posted Friday, August 1, 2014 1:15 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 10:58 PM
Points: 17,600, Visits: 15,461
You can use sp_help_revlogin to help transfer logins.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1598801
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse