SQL Script to retrive DataBase settings before DB restore
select 'Update SysBCProxyUserAccount set SID = ''' + SID + ''' , NETWORKDOMAIN =''' + NETWORKDOMAIN + ''' , NETWORKALIAS = ''' + NETWORKALIAS + '''' from SysBCProxyUserAccount select 'Update SysWorkflowParameters set EXECUTIONUSERID = ''' + EXECUTIONUSERID + '''' from SysWorkflowParameters select 'Update SysServerConfig set SERVERID = ''' + SERVERID + '''' from SysServerConfig select 'Update BatchServerConfig set SERVERID = ''' + SERVERID + '''' from BatchServerConfig select 'Update BatchServerGroup set SERVERID = ''' + SERVERID + '''' from BatchServerGroup select Top 1 'Update Batch set SERVERID =''' + SERVERID + '''' from Batch select 'Update SYSEMAILPARAMETERS set SMTPRelayServerName = ''' + SMTPRelayServe