June 30, 2008 at 5:49 am
We have a server that has been set up to send emails via a number of different database mails accounts, dependant on the client sending the email.
We need to copy the accounts across to another live server, but I can't see a way of scripting them. I could set them all up again, but this will takes hours and I'd to ensure that they are consistent.
I assume I could look at copying the data across from the sysmail tables, but I not entirely sure how to do this.
If anyone has done this could you let me know how you did it?
Thanks in advance
June 30, 2008 at 9:41 am
You could try copying the data over. I'd do it to a dev box first, so if it blows anything up, you haven't messed up a production server.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
June 30, 2008 at 1:01 pm
I just did a quick test but all the tables for mail seems to be very straight forward
For example, [msdb].[dbo].[sysmail_*]
I transferred an account to my test box and aside from having to set up the database mail user role manually it seems to work. I suspect this could be scripted but would need more time than I have right now.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply