Post reply

SQL Mail

  • June 29, 2014 at 6:40 am

    #99918

    I have a production box (2003 SP2) with SQL 2000. There are several backup jobs (full & tran) I have set-up which sends out a notification when the job is complete, sometimes the notification goes out and sometimes it doesn't. the only error message in the log is that the notfication failed to send. What could be the problem were it will send the mail out sometimes and other times it doesn't? Could it be Outlook?

  • June 29, 2014 at 9:18 am

    #1725719

    Where do your backups live? On the SAN, on network attached storage, or ??? If they live on network attached storage, there are many possible reasons including time differences between the server and the machine the backups live on.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • June 29, 2014 at 7:59 pm

    #1725739

    The backup live on the server and then then that directory (a long with the other drives) is backup up to tape every night.

  • July 10, 2014 at 9:02 am

    #1728423

    SQL Mail on SQL 2000 - what a headache.

    Before you engage your Exchange folks I would suggest the 2 following actions:

    - reboot your server

    - drop and recreate your Outlook mail profile

    Why it works I dunno.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply