Skip to content

Instantly share code, notes, and snippets.

@alevyinroc

alevyinroc/Restore with users2.ps1

Created November 1, 2020 21:43
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save alevyinroc/131155c402eaece89d6414ac55969c3d to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save alevyinroc/131155c402eaece89d6414ac55969c3d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Restore with users2.ps1
Invoke-DbaQuery -SqlInstance $DstInstance -Database $DBName -file $DstUserScriptPath;
Write-Output "Users in $DstInstance.$DBName after correcting"
Get-DbaDbUser -sqlinstance $DstInstance -Database $DBName | format-table -autosize -Property SqlInstance, Database, Name, Login;
Write-Output "Orphan users in $DstInstance.$DBName after correcting";
Get-DbaDbOrphanUser -sqlinstance $DstInstance -Database $DBName | format-table -autosize -property SqlInstance, DatabaseName, User;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment