sql 2000 notification services - moving the database to a new server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JR - 12 Sep 2006 23:31 GMT

Is this possible? If so, are there are tools or special steps we need
to take? We have restored the db to a new server and registered the
services using the new server and sql name but it does not work. I
still see refs to the old sql instance name in the NS db though.

Reply to this Message

Joe Webb - 13 Sep 2006 11:48 GMT

See if this helps....
http://sqlns.blogspot.com/2006/07/moving-sqlns-database.html

Joe

Signature

Joe Webb
SQL Server MVP
http://www.sqlns.com

~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811

I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)

>Is this possible? If so, are there are tools or special steps we need
>to take? We have restored the db to a new server and registered the
>services using the new server and sql name but it does not work. I
>still see refs to the old sql instance name in the NS db though.

Reply to this Message

JR - 13 Sep 2006 19:12 GMT

This seems to be related to sql2005 notification services, is that
right? I need to move NS 2.0 with sql2000.

Reply to this Message

Joe Webb - 14 Sep 2006 12:54 GMT

Everything in the article that describes how to move a databse should
apply to 2000 as well as 2005. The only things that are 2005 specific
are:
- you cannot create your SQLNS objects in an existing database in
2000.
- updating must be done using the NSControl command line utility
rather than the GUI.

HTH...

Signature

>This seems to be related to sql2005 notification services, is that
>right? I need to move NS 2.0 with sql2000.

Reply to this Message