Activity overview
Latest activity by ev89pimp
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...
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 ...
Include log text in notification emails
Is there a way to get the output from Sql Backup Restores to be outputted in the notifications that are sent out by SQL 2005? I'm using the extended stored procedure and it would be nice if the act...
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...
SQB46 fails to move/delete processed log files
Hello all,
I'm having an issue with SQB Pro that only manifests itself under periods of heavy load on the target server. Here is a little background information:
We have a primary server and backup...