Home Forums Programming Powershell implementing backup system using PS (a newbie question) RE: implementing backup system using PS (a newbie question)

  • As has been stated before, you should probably set up a backup job, on each server, using regular t-sql. No need to do the backups from a singular location. But, if that is what you want, then what i posted above should work. If you do a backup, from each server, using SQL Agent, then you can set up a notification, on failure. As a further sanity check we run a job that checks to see if a backup did not complete, in the last 24 hours. We also have another report that checks to see if a SQL job failed, in the last 24 hours.

    See attached.

    Leonard