This article original URL is https://msdn.microsoft.com/en-us/library/ee406927.aspx
Backing Up and Restoring Logins
You can back up and restore logins using a script as described in the following procedures.
To back up a login using a script
-
Open SQL Server Management Studio.
-
Expand Security, and expand the list of Logins.
-
Right-click the login you want to create a backup script for, and then select Script Login as.
-
Select CREATE To, and then select one of New Query Editor Window, File, or Clipboard to select a destination for the script. Typically, the destination is a file with a .sql extension.
-
Repeat this procedure from Step 3 for each login you want to script. Refer to the list of BizTalk Server related logins to determine which logins you need to script.
To restore a login from a script
-
Open SQL Server Management Studio.
-
On the File menu, Open the file containing the scripted login.
-
Execute the script to create the login.
綜合知識 (3)