notification from log shipping
I'm on my third day of testing 'log shipping'. I maintain quite a few SQL Servers at different locations, it would be nice if the app could notify me that things were going well.
I don't want a 'failure' notification, I'm looking for *one* daily notification of status. (I've got it set to ship every 15 minutes). I'd like that to come from the backup server, not the live server.
Anything like that possible?