sql 2005 copying dbmail configuration between servers

microsoft.public.sqlserver.server

27 Nov 2007 1:45 PM

Piotr Lipski

Hi.

Does anyone know how to copy Database Mail configuration from one SQL
Server 2005 instance to another?

There is only one (relatively simple) DB Mail profile to copy so I can
just re-create it on the destination server from scratch but I'm just
wondering if there is better method. What if I had 100 profiles...

--
PL

27 Nov 2007 2:59 PM

Piotr Lipski

Piotr Lipski wrote:

> Hi.
>
> Does anyone know how to copy Database Mail configuration from one SQL
> Server 2005 instance to another?

Solved. sysmail_* tables in msdb

--
PL

27 Nov 2007 3:03 PM

John Bell

Hi

You could write a script that will do this using SMO and then point it to
the instance you wish to configure.

http://msdn2.microsoft.com/en-us/library/ms162147.aspx

John

Show quote

"Piotr Lipski" wrote:

> Hi.
>
> Does anyone know how to copy Database Mail configuration from one SQL
> Server 2005 instance to another?
>
> There is only one (relatively simple) DB Mail profile to copy so I can
> just re-create it on the destination server from scratch but I'm just
> wondering if there is better method. What if I had 100 profiles...
>
> --
> PL
>