查找主体和镜像服务器之间丢失的登录和丢失的作业的最佳方法

使用 Power Shell 对我有用。我把它作为更大脚本的一部分，我只提供它的一部分。希望你能把它放在一起。

FUNCTION report-status-primary 
    {
        PARAM (
                $Check,
                $Variable,
                $Primary,
                $Secondary
              )

        WRITE-HOST "Checking $Check on $Primary..." -ForegroundColor Yellow
        IF ($Variable)

            {

                WRITE-HOST "$Check on $primary not on $secondary" -ForegroundColor Red
                $Variable
            }
        ELSE
            {
                WRITE-HOST "Match" -ForegroundColor Green
            }     
        WRITE-HOST "------------------------------------------------------------" -ForegroundColor Yellow
    }

  FUNCTION report-status-secondary 
    {
        PARAM (
                $Check,
                $Variable,
                $Primary,
                $Secondary
              )

        WRITE-HOST "Checking $Check on $Secondary..." -ForegroundColor Yellow
        IF ($Variable)

            {

                WRITE-HOST "$Check on $Secondary not on $primary" -ForegroundColor Red
                $Variable
            }
        ELSE
            {
                WRITE-HOST "Match" -ForegroundColor Green
            }     
        WRITE-HOST "------------------------------------------------------------" -ForegroundColor Yellow
    }

多变的：

$SourceSQLServer = 'Primary Server'
$TargetSQLServer = 'Secondary Server'

[System.Reflection.Assembly]::LoadWithPartialName('Microsoft.SqlServer.SMO') | Out-Null
$SourceServer = New-Object 'Microsoft.SqlServer.Management.SMO.Server' ($SourceSQLServer)
$TargetServer  = New-Object 'Microsoft.SqlServer.Management.SMO.Server' ($TargetSQLServer)

# -- Jobs
$JobsSNT = $SourceServer.JobServer.Jobs.name | where {($TargetServer.JobServer.Jobs.name -notcontains $_) -and $_ -notlike "*]__*" }
$JobsTNS = $TargetServer.JobServer.Jobs.name | where {($SourceServer.JobServer.Jobs.name -notcontains $_) -and $_ -notlike "*]__*" }

# -- Logins
$LoginsSNT = $SourceServer.Logins.name | where {$TargetServer.Logins.name -notcontains $_}
$LoginsTNS = $TargetServer.Logins.name | where {$SourceServer.Logins.name -notcontains $_}

报告：

report-status-primary -check 'Jobs' -variable $JobsSNT -primary $SourceServer -secondary $TargetServer 
report-status-secondary -check 'Jobs' -variable $JobsTNS -primary $SourceServer -secondary $TargetServer 

report-status-primary -check 'Logins' -variable $LoginsSNT -primary $SourceServer -secondary $TargetServer 
report-status-secondary -check 'Logins' -variable $LoginsTNS -primary $SourceServer -secondary $TargetServer 

这是我运行此脚本的示例输出。