Comments
Sort by recent activity
Hi,
The reason I would like to be able to get results via SQL emails instead of SQB is simply for consolidation reasons. I'd rather not get job emails from SQL, then job emails from SQB as well.. Also, when notifications and email addresses are added/changed, I would have to change the mailto address in each and every job... definitely not scalable.
Like I said, if I had to use SQB mailto I will, but I see it as a short term solution as we still have only 12 DBs we are log shipping, but that could change in the near future.
Thanks,
E / comments
Hi,
The reason I would like to be able to get results via SQL emails instead of SQB is simply for consolidation reasons. I'd rather not get job emails from SQL, then job emails from SQB as well.. A...
I'm willing to use MAILTO as a workaround, but what I was really looking for was a way for SQB to pass the results of the stored procedure to SQL's own reporting system. I'm not using notification services yet, just database mail with SMTP.
Basically, when I run the command used in a stored procedure in a query window, the results I see in the lower pane is what I would like to see in an email.
thanks / comments
I'm willing to use MAILTO as a workaround, but what I was really looking for was a way for SQB to pass the results of the stored procedure to SQL's own reporting system. I'm not using notification ...
Argh, looks like I didn't audit failed deletions for the right users... I'll have to wait another week to try..
On a side note, I've noticed monster disk queueing happening on the data drive on this database server around the same time the files aren't deleted. Has anyone seen this situation cause Windows NOT to delete a file when asked? Maybe the queue gets so long that the deletion request times out?
thanks,
E / comments
Argh, looks like I didn't audit failed deletions for the right users... I'll have to wait another week to try..
On a side note, I've noticed monster disk queueing happening on the data drive on thi...
I'll enable and see if I can get anything useful out of it. The stock event logging didn't show any errors or warnings. I'll post results after this weekend's processing run. / comments
I'll enable and see if I can get anything useful out of it. The stock event logging didn't show any errors or warnings. I'll post results after this weekend's processing run.
There is no copy at all in the processed folder... It is simply "gone" from the NOTPROCESSED folder and the PROCESSED folder as well.... / comments
There is no copy at all in the processed folder... It is simply "gone" from the NOTPROCESSED folder and the PROCESSED folder as well....
Hi all, since I have gotten no replies, I want to add that I also tried to change the restore frequency to every half hour instead of every 15 minutes, and it had no effect.
The backup server (target) is a clean build of Windows 2003, running SQL 2005, and nothing else! I have dual 2.4ghz xeons and 4GB ram...I can't figure out why SQB would have an issue moving the file and if it did, why it would say it moved it!!
HELP [image] / comments
Hi all, since I have gotten no replies, I want to add that I also tried to change the restore frequency to every half hour instead of every 15 minutes, and it had no effect.
The backup server (targ...