Ensure that the SQLAgent has been setup correctly also to use mail.

If you have not set the Agent properties Alert System to use DBMail and the profile and restarted...

• This reply was modified 1 month ago by homebrew01.
• This reply was modified 1 month ago by homebrew01.

For now, I am able to add a step to the job to send an email if the previous backup step failed.

EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'XXXXX_MailProfile',
@body = 'Failure...

• This reply was modified 1 month ago by homebrew01.
• This reply was modified 1 month ago by homebrew01.

Idera, Redgate, a few others. They probably offer a free trial so you can find what's best for you.

There's not a lot of traffic here, but there are some knowledgeable people who might be able to help.

https://code400.com/forum/forum

Practice doing BACKUP / RESTORE before you actually need to. Save your backups in another location in case your PC crashes.

Script the RESTORE on Server A, then use FIND/REPLACE to change the destination path to be run on Server B

A few years ago I created a job that sent me an email if any job ran 'X' times longer than it's average run time. Maybe that would work ?

I...

Thanks for the reply Ant, I was looking for the process and you seem to have hinted at it.

Unfortunately we don't have a .bak from before the target to...

Thanks for the replies.

Is there a Windows service that needs to start ?

Dummy  Reply to force page 2 to display. This "Post 16" bug is STILL not fixed. Going on 2 years. Sigh....

• This reply was modified 1 year, 6 months ago by homebrew01.
• This reply was modified 1 year, 6 months ago by homebrew01.
• This reply was modified 1 year, 6 months ago by homebrew01.
• This reply was modified 1 year, 6 months ago by homebrew01.

I would like to understand how to create auto job to take the full backup, transaction backup + truncating the log files(without making the database to simple recovery mode...

• This reply was modified 1 year, 6 months ago by homebrew01.
• This reply was modified 1 year, 6 months ago by homebrew01.
• This reply was modified 1 year, 6 months ago by homebrew01.

DUPLICATE POST. Reply here:

https://www.sqlservercentral.com/forums/topic/error-message-in-launching-web-service-url-in-sql-report-server-2#post-4299487

Replying to get past dreaded 16 reply, page 2 forum bug.

Hello ? Still broken.