Activity overview
Latest activity by Proto
Activity History will not load
Version 10.1.16.1886I can't seem to get the Activity History to load for my local server & DB.A strange thing: when I first start the UI, if I click on the server. I can see the history for the ser...
So I found this command DECLARE @settings varchar(1024) EXEC master..sqbutility 1008, @settings OUTPUT SELECT @settings which showed the email settings as blank, even thought they show in the UI. went back to the UI and moved the port from 25 to 26 and back again to enable the Apply button. Clicked that and now the settings are saved in the db. Now scheduled jobs can find them and things run as expected. So... weird / comments
So I found this commandDECLARE @settings varchar(1024)EXEC master..sqbutility 1008, @settings OUTPUTSELECT @settingswhich showed the email settings as blank, even thought they show in the UI.went b...
The current permissions issue seems to be causing scheduled jobs to not send out emails. Even though the test runs fine. Warning 150: MAILTO error: SMTP host name not defined. SQLBackupAgent has Admin permissions, but I suspect it's running as NETWORK SERVICE / comments
The current permissions issue seems to be causing scheduled jobs to not send out emails. Even though the test runs fine.Warning 150: MAILTO error: SMTP host name not defined.SQLBackupAgent has Admi...
Why do scheduled jobs run as network service?
I don't understand. Why bother setting up a specific account that the SQL Backup Agent runs under when scheduled jobs just ignore it and try and run under NETWORK SERVICE? SQL Backup Agent is runni...
Table data copy without row by row comparison?
Is it possible to use data compare to copy the entire contents of a table without using the row by row comparison?For example, to copy data from live down to dev.The tables i'm dealing with are muc...
Apologies for jumping on here, but is this a known issue? I'm having the same problem on a new install of version 8.0.1.405 / comments
Apologies for jumping on here, but is this a known issue? I'm having the same problem on a new install of version 8.0.1.405
Nope. The full backup runs nearly a day before (3AM Sunday morning) and was complete a long time before the transaction log backup ran.
Like I said, the confusing part is that there is nothing else going on at this time. Looking at our monitoring software (SQL Sentry) there is nothing that jumps out. CPU usage is ~3%. No other queries running. No deadlocks or blocking. / comments
Nope. The full backup runs nearly a day before (3AM Sunday morning) and was complete a long time before the transaction log backup ran.
Like I said, the confusing part is that there is nothing else...
VDI error 1010
I'm getting this error when running my transaction log backup on sunday nights. I get the error, it retries and then goes through fine. The transaction log backup is scheduled to run every night at...
dlkj wrote:
You will need to have a friendly chat with your Sys Admin.
Your company SMTP server has been configured to reject certain email addresses or sending machines. This is a common restriction to prevent Spam and Malware propagation.
I'm guessing the machine that you are using for the SQL Response Alert Repository is not a SQL Server and therefore might not be white listed to have sending privileges on the SMTP Server.
Cheers,
--
Daniel
As I said, I use the exact same settings in SQL Backup (running on the exact same server (it's the SQL server)) and they work just fine, emails are sent with no problems. / comments
dlkj wrote:
You will need to have a friendly chat with your Sys Admin.
Your company SMTP server has been configured to reject certain email addresses or sending machines. This is a common restri...