Preet (6/16/2008)
Deepak's link will give you what you want. Its been improved since I last needed it. Default databases etc. The key thing is the copying of the SIDs.
This is a good point. The Microsoft scripts do ensure the SID is carried over. This is important because that's how the login maps into the database as a user. Without using the Microsoft scripts, you'd have to run sp_change_users_login to reconcile whenever you had to switch-over to the standby system.
K. Brian Kelley
@kbriankelley