Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Moving Instances of Notification Services

SQL Server 2005

Typically when you move from the development phase to the test phase, or from the test phase to the production phase, you re-create the instance of Notification Services, which re-creates the databases used by the instance of Notification Services. However, if you want to keep the existing data, you can move the instance of Notification Services and its databases instead.

When you move an instance of Notification Services, besides the obvious step of installing software and moving files to the new server or servers, you must also update the instance of Notification Services to specify the name of the new instance of the Database Engine and the new system name for each hosted event provider, generator, and distributor. You must also make sure that the instance registration for engine components and client components point to the new instance of the Database Engine.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.