I have contacted the Admin for Active DIR, I asked him to verify that the SQL IP address was able to send out to the smtp server....

to be continued tomorrow....

😀

Well that wasn't it,

Netsend had an error after restarting SQL Agent Services, but that's okay, it was a DOS executable that has been discontinued by MS from what I understand.

I think I have found something....Stay Tuned...

Here is my error;

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 5 (Date and Time of error). Exception Message:...

Also the State = INACTIVE - BOO

Thanks Lowell, The message is failed, it tries to send but fails. I can ping the smtp server and send using telnet. below are the queries I ran and was...

are you taking a backup or trying to restore? if you are restoring you should not use mdf or ldf, only use .bak files or 3rd party vendor backups. Can...

well I removed all profiles and accounts, used tsql to profiles and accounts back, and tried again, the mail is still failing.

any ideas????

try this site, you can download.

http://sqlserverpedia.com/blog/sql-server-bloggers/feature-packs-for-sql-server-and-ssis/

do you have the logs from symantec? if the error is still cryptic in the windows logs, sounds like it is, it would be best to turn there. As before...

Look in the windows log application log.

The compare generates a script at the end, if you sync it, it is possible that it will over write your DB. Check your settings, don't sync the DB's, and...

so you are using the tool to output a query so you can add your standards to the DB?

btw, i love RG, I use it all the time and have...

BACKUP failed to complete the command BACKUP DATABASE MyDB. Check the backup application log

- This basically says 'your backup command failed, go to the application log to find out...

there are two ways to see where cluster nodes are;

1) go to Start> Administrative Tools> Failover Cluster Manager.

Click on the server cluster name

Click on Nodes

This will show you two instance...