October 29, 2009 at 8:30 am
I have couple of email profiles created in the production for email notifications. I am setting up new DR server and I want to create same profiles in DR server with same configurations. How to Script/transfer the existing production profiles to other server?
Appreciate your help on this. Thanks!
October 29, 2009 at 10:15 am
I haven't had the need to do this and I don't see an obvious way to script a profile. It looks like you could select from msdb.dbo.sysmail_profile and msdb.dbo.account and use the data returned to set the parameters for sysmail_add_account_sp and sysmail_add_profile_sp.
Greg
October 29, 2009 at 12:00 pm
Thanks Greg. I thought scripting is possible. I will go ahead your suggestion
October 29, 2009 at 1:40 pm
IMO easyest is to script it all and execute the scripts at the target instance.
Keep in mind to also script the granted usage rights.
What do you need to script ?
have a look at http://www.mssqltips.com/tip.asp?tip=1736
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
October 30, 2009 at 12:10 pm
Thanks all. Created required script.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply