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

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

JR
9/12/2006 3:31:17 PM

sql server notification services: 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.

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

Joe Webb
9/13/2006 12:00:00 AM

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

Joe

--
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)

[quoted text, click to view]

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

JR
9/13/2006 11:12:49 AM

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

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

Joe Webb
9/14/2006 6:54:19 AM

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...

--
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)

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server notification services group.