0

I have to check multiple servers daily to find their backup folders (and maybe other data, like backup time, databases and backuptype).

Is there anyway to write a script to list the backup folder if I know the name of the Maintenance Plan?

I found this helpful, but it requires the backup to have been run at least once.

Community
  • 1
  • 1
Stiegler
  • 719
  • 6
  • 8

1 Answers1

0

Configure/Enable database mail.

Then just create an operator for each job, everytime the job fail, the operator will send out an email.

This link has a detailed approach, on how to configure your alerts.

Arun
  • 941
  • 6
  • 13
  • Thank you. :) I wish to automate the procedure and I'm looking into SSIS and powershell options, alas, currently without any luck. – Stiegler Apr 18 '15 at 08:20