@primary_server = ‘current_primary_server_name’,
@secondary_server = ‘current_secondary_server_name’,
@database = ‘current_secondary_dbname’,
@new_source = ‘new_source_directory’
5. 在次要服务器上解析登入帐号
use master
exec sp_resolve_logins
@dest_db = ‘dbname’,
@dest_path = ‘destination_path’,
@filename = ‘filename’ (from step 1 export)
6. 连接数据库存取与权限。将转移后已解析的登入帐号连结至相对应的数据库使用者及其权限. (sql book online 缺少此步)
use sourcename
exec sp_change_users_login ‘update_one’ , ‘username’ , ‘loginname’
