This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 81%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDM%3C/text%3E%3C/svg%3E)
<#
Script: Backup database with email notification
Version 1.3 - May. 31, 2024
This script performs full and transaction log backups of the Mobile database and sends email notifications.
#>
$serverName = "TFS"
$databaseName = "Mobile"
$backupPath = "\10.0.0.228\Backup"
$timestamp = (Get-Date).ToString("yyyyMMddHHmmss")
$logFilePath = "$backupPath\MobileBackupLog_$timestamp.log"
$smtpServer = "ded4829.inmotionhosting.com"
$smtpPort = 587
$from = "donotreply@email.alliancewebpos.com"
$to = "dmarquez@asi-dev6.com"
$subject = "Mobile Backup Notification"
$mailUsername = "donotreply@email.alliancewebpos.com"
$mailPassword = "!D0n0tR3pLyp4zz82!x!"
function Log-Message {
param (
[string]$message,
[string]$logFile
)
Add-content -Path $logFile -Value "$([DateTime]::Now) - $message"
}
function Run-SqlCommand {
param (
[string]$server,
[string]$query,
[string]$backupType,
[string]$filePath,
[string]$logFile
)
try {
$cmd = "sqlcmd -S $server -Q `"$query`""
Invoke-Expression $cmd
if (Test-Path $filePath) {
Log-Message "Successfully created $backupType backup file: $filePath" -logFile $logFile
} else {
Log-Message "$backupType backup file not found: $filePath" -logFile $logFile
}
}
catch {
Log-Message "Error executing $backupType backup: $query. Error: $_" -logFile $logFile
}
}
function Send-EmailNotification {
param (
[string]$smtpServer,
[int]$smtpPort,
[string]$from,
[string]$to,
[string]$subject,
[string]$username,
[string]$password,
[string]$body,
[string]$logFile
)
try {
$smtpClient = New-Object Net.Mail.SmtpClient($smtpServer, $smtpPort)
$smtpClient.EnableSsl = $true
$smtpClient.Credentials = New-Object System.Net.NetworkCredential($username, $password)
$mailMessage = New-Object Net.Mail.MailMessage
$mailMessage.From = $from
$to.Split(",") | ForEach-Object { $mailMessage.To.Add($_.Trim()) }
$mailMessage.Subject = $subject
$mailMessage.Body = $body
$smtpClient.Send($mailMessage)
Log-Message "Email notification sent successfully." -logFile $logFile
} catch {
Log-Message "Failed to send email notification. Exception type: $($_.Exception.GetType().FullName)" -logFile $logFile
Log-Message "Exception message: $($_.Exception.Message)" -logFile $logFile
Log-Message "Stack trace: $($_.Exception.StackTrace)" -logFile $logFile
if ($_.Exception.InnerException) {
Log-Message "Inner exception type: $($_.Exception.InnerException.GetType().FullName)" -logFile $logFile
Log-Message "Inner exception message: $($_.Exception.InnerException.Message)" -logFile $logFile
Log-Message "Inner exception stack trace: $($_.Exception.InnerException.StackTrace)" -logFile $logFile
}
}
}
if (-not (Test-Path $backupPath)) {
New-Item -Path $backupPath -ItemType Directory
}
$backupPathFull = "$backupPath\Mobile_Full_$timestamp.bak"
$backupPathTrn = "$backupPath\Mobile_Log_$timestamp.trn"
$backupFull = "BACKUP DATABASE [$databaseName] TO DISK = N'$backupPathFull' WITH NOFORMAT, NOINIT, NOSKIP, REWIND, NOUNLOAD, STATS = 10"
$backupTrn = "BACKUP LOG [$databaseName] TO DISK = N'$backupPathTrn' WITH NOFORMAT, NOINIT, NOSKIP, REWIND, NOUNLOAD, STATS = 10"
Log-Message "Starting full backup of database '$databaseName'..." -logFile $logFilePath
Run-SqlCommand -server $serverName -query $backupFull -backupType "full" -filePath $backupPathFull -logFile $logFilePath
Log-Message "Starting transaction log backup of database '$databaseName'..." -logFile $logFilePath
Run-SqlCommand -server $serverName -query $backupTrn -backupType "transaction log" -filePath $backupPathTrn -logFile $logFilePath
$backupStatus = "Success" # Assume success unless an error is encountered
Log-Message "Backup process completed with status: $backupStatus." -logFile $logFilePath
$logFileContent = Get-Content $logFilePath -Raw
$emailBody = @"
Backup process for database '$databaseName' completed.
Backup files:
Log file content:
$logFileContent
"@
try {
Send-EmailNotification -smtpServer $smtpServer -smtpPort $smtpPort -from $from -to $to -subject $subject -username $mailUsername -password $mailPassword -body $emailBody -logFile $logFilePath
} catch {
$backupStatus = "Failed"
Log-Message "Failed to send email notification. Backup status: $backupStatus. Exception: $_" -logFile $logFilePath
}
Error below:
06/04/2024 15:16:50 - Failed to send email notification. Exception type: System.Management.Automation.MethodInvocationException
06/04/2024 15:16:50 - Exception message: Exception calling "Send" with "1" argument(s): "Failure sending mail."
06/04/2024 15:16:50 - Stack trace: at System.Management.Automation.ExceptionHandlingOps.ConvertToMethodInvocationException(Exception exception, Type typeToThrow, String methodName, Int32 numArgs, MemberInfo memberInfo)
at CallSite.Target(Closure , CallSite , Object , Object )
at System.Dynamic.UpdateDelegates.UpdateAndExecute2T0,T1,TRet
at System.Management.Automation.Interpreter.DynamicInstruction`3.Run(InterpretedFrame frame)
at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame)
06/04/2024 15:16:50 - Inner exception type: System.Net.Mail.SmtpException
06/04/2024 15:16:50 - Inner exception message: Failure sending mail.
06/04/2024 15:16:50 - Inner exception stack trace: at System.Net.Mail.SmtpClient.Send(MailMessage message)
at CallSite.Target(Closure , CallSite , Object , Object )
$backupPath = "\10.0.0.228\Backup"
If you want to backup to an UNC path then you have to use double-backslash; fix that first =>
$backupPath = "\\10.0.0.228\Backup"
He posted the script without using a code block. That's why its formatting is all messed up. I think it treats the first backslash as an escape character. The pound sign which should be a Powershell comment gets interpreted as a bold title.
@Dyan Marquez please edit your question and post your script in a code block.
And are you sure that your server supports SMTP connections.
PS C:\> Test-NetConnection ded4829.inmotionhosting.com -port 587
WARNING: TCP connect to (173.231.200.107 : 587) failed
ComputerName : ded4829.inmotionhosting.com RemoteAddress : 173.231.200.107 RemotePort : 587 InterfaceAlias : Wi-Fi SourceAddress : 192.168.1.4
PingSucceeded : True
PingReplyDetails (RTT) : 75 ms
TcpTestSucceeded : False
it has been corrected sir but still an error
And your post / code is still not readable.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 8%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPP%3C/text%3E%3C/svg%3E)
Hi @Dyan Marquez ,
I tested your Send-EmailNotification function with active email via smtp.outlook.com and it works fine. It looks like a problem with the internal configuration of the SMTP server that you have provided.
If this is indeed the case, please mark my answer as "Accepted" and perhaps come back and share the solution.
ok sir i will look into it
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 74%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
I there a reason why you've chosen to use the Net.Mail.SmtpClient class to send the email instead of the simpler Send-MailMessage cmdlet (which uses the same .Net class)?
Is this script being run using your credentials, or is it run from a scheduled task? If it's a scheduled task keep in mind that the credentials maybe those of the System account!
If you want to continue using the .Net class directly, try setting the SmtpClients' UseDefaultcredentials to $false. You're supplying the credentials already.
Here's a neatened up version your original code:
<#
Script: Backup database with email notification
Version 1.3 - May. 31, 2024
This script performs full and transaction log backups of the Mobile database and sends email notifications.
#>
#Variables
$serverName = "TFS"
$databaseName = "Mobile"
$backupPath = "\\10.0.0.228\Backup"
$timestamp = (Get-Date).ToString("yyyyMMddHHmmss")
$logFilePath = "$backupPath\MobileBackupLog_$timestamp.log"
#Email configuration
$smtpServer = "ded4829.inmotionhosting.com"
$smtpPort = 587
$from = "donotreply@email.alliancewebpos.com"
$to = "dmarquez@asi-dev6.com"
$subject = "Mobile Backup Notification"
$mailUsername = "donotreply@email.alliancewebpos.com"
$mailPassword = "!D0n0tR3pLyp4zz82!x!"
#Function to log messages to a file
function Log-Message {
param (
[string]$message,
[string]$logFile
)
Add-Content -Path $logFile -Value "$([DateTime]::Now) - $message"
}
#Function to run a SQL command using sqlcmd and log the result
function Run-SqlCommand {
param (
[string]$server,
[string]$query,
[string]$backupType,
[string]$filePath,
[string]$logFile
)
try {
$cmd = "sqlcmd -S $server -Q `"$query`""
Invoke-Expression $cmd
if (Test-Path $filePath) {
Log-Message "Successfully created $backupType backup file: $filePath" -logFile $logFile
}
else {
Log-Message "$backupType backup file not found: $filePath" -logFile $logFile
}
}
catch {
Log-Message "Error executing $backupType backup: $query. Error: $_" -logFile $logFile
}
}
#Function to send email notification
function Send-EmailNotification {
param (
[string]$smtpServer,
[int]$smtpPort,
[string]$from,
[string]$to,
[string]$subject,
[string]$username,
[string]$password,
[string]$body,
[string]$logFile
)
try {
$smtpClient = New-Object Net.Mail.SmtpClient($smtpServer, $smtpPort)
$smtpClient.EnableSsl = $true
$smtpClient.Credentials = New-Object System.Net.NetworkCredential($username, $password)
$mailMessage = New-Object Net.Mail.MailMessage
$mailMessage.From = $from
$to.Split(",") | ForEach-Object { $mailMessage.To.Add($_.Trim()) }
$mailMessage.Subject = $subject
$mailMessage.Body = $body
$smtpClient.Send($mailMessage)
Log-Message "Email notification sent successfully." -logFile $logFile
}
catch {
Log-Message "Failed to send email notification. Exception type: $($_.Exception.GetType().FullName)" -logFile $logFile
Log-Message "Exception message: $($_.Exception.Message)" -logFile $logFile
Log-Message "Stack trace: $($_.Exception.StackTrace)" -logFile $logFile
if ($_.Exception.InnerException) {
Log-Message "Inner exception type: $($_.Exception.InnerException.GetType().FullName)" -logFile $logFile
Log-Message "Inner exception message: $($_.Exception.InnerException.Message)" -logFile $logFile
Log-Message "Inner exception stack trace: $($_.Exception.InnerException.StackTrace)" -logFile $logFile
}
}
}
#Ensure backup directory exists
if (-not (Test-Path $backupPath)) {
New-Item -Path $backupPath -ItemType Directory
}
#Create a timestamp for the backup filenames
$backupPathFull = "$backupPath\Mobile_Full_$timestamp.bak"
$backupPathTrn = "$backupPath\Mobile_Log_$timestamp.trn"
#Full backup T-SQL command
$backupFull = "BACKUP DATABASE [$databaseName] TO DISK = N'$backupPathFull' WITH NOFORMAT, NOINIT, NOSKIP, REWIND, NOUNLOAD, STATS = 10"
#Transaction log backup T-SQL command
$backupTrn = "BACKUP LOG [$databaseName] TO DISK = N'$backupPathTrn' WITH NOFORMAT, NOINIT, NOSKIP, REWIND, NOUNLOAD, STATS = 10"
#Perform the full backup
Log-Message "Starting full backup of database '$databaseName'..." -logFile $logFilePath
Run-SqlCommand -server $serverName -query $backupFull -backupType "full" -filePath $backupPathFull -logFile $logFilePath
#Perform the transaction log backup
Log-Message "Starting transaction log backup of database '$databaseName'..." -logFile $logFilePath
Run-SqlCommand -server $serverName -query $backupTrn -backupType "transaction log" -filePath $backupPathTrn -logFile $logFilePath
#Final log message
$backupStatus = "Success" # Assume success unless an error is encountered
Log-Message "Backup process completed with status: $backupStatus." -logFile $logFilePath
#Read the content of the log file
$logFileContent = Get-Content $logFilePath -Raw
#Send email notification
$emailBody = @"
Backup process for database '$databaseName' completed.
Backup files:
Full backup: $backupPathFull
Transaction log backup: $backupPathTrn
Log file content:
$logFileContent
"@
try {
Send-EmailNotification -smtpServer $smtpServer -smtpPort $smtpPort -from $from -to $to -subject $subject -username $mailUsername -password $mailPassword -body $emailBody -logFile $logFilePath
}
catch {
$backupStatus = "Failed"
Log-Message "Failed to send email notification. Backup status: $backupStatus. Exception: $_" -logFile $logFilePath
}
@Rich Matheisen if you run "Send-MailMessage" in PowerShell 7+, you get this warning:
WARNING: The command 'Send-MailMessage' is obsolete. This cmdlet does not guarantee secure connections to SMTP servers. While there is no immediate replacement available in PowerShell, we recommend you do not use Send-MailMessage at this time. See https://aka.ms/SendMailMessage for more information.
"Obsolete" doesn't mean "won't work" -- at least not yet. Notice how MS has rushed a replacement for a widely use cmdlet???
If you read the link you enclosed, you'd have seen that it refers to the SMTPClient .Net class -- which is what the Send-MailMessage uses, and what you used in your code!
You could try using this: https://github.com/ArchitektApx/Send-O365EWSMailMessage (but it uses EWS and I don't know when that was last updated; also see that it lacks the SMTPServer parameter).
You can also use Send-MgUserMail.
Or you can use MimeKit and MailKit. <== these work with ANY SMTP server. There;s eve a PowerShell cmdlet! https://www.powershellgallery.com/packages/Send-MailKitMessage/3.1.0