Home Forums SQL Server 2005 Administering Log Shipping RE: Log Shipping
SQL_DBA_3
SSCarpal Tunnel
Points: 4772
More actions
March 17, 2009 at 10:58 pm
#961577
You can script out the logins and database jobs and run them in master and msdb databases respectively on the secondary server(which is now online)
For user mapping use sp_change_users_login which maps the SIDs of the logins and users.