Set-sqmDatabaseOwner
Examples
# Set sa account on all user databases
# Set sa account on all user databases
Set-sqmDatabaseOwner -SqlInstance "SQL01"
# Specific databases with a custom login
# Specific databases with a custom login
Set-sqmDatabaseOwner -SqlInstance "SQL01" -Database "Prod*" -OwnerLogin "svc_sqlowner"
# Pipeline across multiple instances
# Pipeline across multiple instances
'SQL01','SQL02' | Set-sqmDatabaseOwner
# WhatIf - only show what would be changed
# WhatIf - only show what would be changed
Set-sqmDatabaseOwner -SqlInstance "SQL01" -WhatIf
Copy-sqmNTFSPermissions -SourcePath "D:\" -DestinationPath "E:\" -Recurse
Copy-sqmNTFSPermissions -SourcePath "D:\" -DestinationPath "E:\" -Recurse
Copies all permissions from D: to E: (recursively).
Copy-sqmNTFSPermissions -SourcePath "D:\Daten" -DestinationPath "E:\Daten" -Recurse -CreateMissingFolders
Copy-sqmNTFSPermissions -SourcePath "D:\Daten" -DestinationPath "E:\Daten" -Recurse -CreateMissingFolders
Copies permissions and creates missing target folders.