Guest User!

You are not Sophos Staff.

Thread Info
  • State Verified Answer
  • Locked Locked
  • Replies 3 replies
  • Subscribers 0 subscribers
  • Views 11537 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

What does PureMessage store in SQL?

Kos-Symbion

I know Puremessage needs SQL but what does it use it for?

Are actual items like quarantined emails stored or just configuration details?

I'm looking at installing 3.1.2 on  Exchange 2010SP2 box and want to work out whether to use SQL server across WAN or install local SQL on same box.

Thanks,

Kos

:27953


This thread was automatically locked due to age.
  • 0

    Hi Kos,

    PureMessage for Exchange uses the database for four functions:

    1. Configuration (including the policy, the SQL settings, alert notifications, Exchange paths, etc.)
    2. Directory information, meaning if AD synchronization is configured, then the mapping of usernames to groups and email addresses (for policy, recipient validation, etc.)
    3. Quarantined email messages
    4. Reporting information, tied to statistics tied to email flow, policy rule hits, etc.

    Depending on your Exchange environment, you can choose to install SQL locally for PureMessage if you're working with a simple single Exchange server or two. However, if your Exchange environment turns out to be far larger, or spans multiple physical locations, a dedicated SQL server may work better to share all your settings.

    :28023
  • 0

    We have 7 exchange 2007 boxes some at remote office locations with 5 having Puremessage installed.

    I'm rolling ouot new Exchange 2010SP2 installs.

    Since it stores quarantined email messages I'd be concerned if there was an outbreak and large messages were being qurantined across WAN connections.

    On the other hand I dont particularly want to install SQL locally on each of the Exchange servers.

    In terms of the Management console is there any difference if the SQL is local or Remote ?

    Can you confirm it just uses DCOM over the network to communicate.

    Thanks,

    Kos

    :28025
  • 0

    Regarding the quarantine release, the actual quarantined message is also stored at the file system level of the Exchange box where the email arrived. This means that the request to release will be handled primarily at the Exchange end, so the database won't be copying over large chunks of data.

    Otherwise, communications with SQL work via TCP/IP and named pipes.

    From a console standpoint, there is no major difference between running the SQL locally or remotely. However, in your environment, if you want to share the same policy and configuration with all these Exchange systems, you can pick one server within your main office to house the SQL, regardless if PureMessage is installed or not on the same system. This would allow for a single console for administering your servers.

    :28193