Creating database mail with DBA TOOLS powershell script


The below query will configure database profile and account on multiple sql server named instance.

cls
$instanceNames=@("defaultinstance","named\instance1","named\instance2")
$instanceNames|
ForEach-Object{
$InstanceName=$_
New-DbaDbMailAccount `
-SQLinstance $InstanceName `
-Name "DBHealth"`
-DisplayName "AOAG Health Failed" `
-Description "DatbaseHealthCheck" `
-EmailAddress "support@sql.com" `
-ReplyToAddress "support@sql.com" `
-MailServer "mailserveramehere" `
-Force

New-DbaDbMailProfile `
-SqlInstance $InstanceName `
-MailAccountName "DBHealth" `
-Name "DBHealthProfile" `

}

Comments

Popular posts from this blog

System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out

Pre login Handshake or Connection Timeout Period

Transparent Data Encryption(TDE) with Master Key and Certificate in SQL Server