Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Replacing the Biztalk SQL nodes
- This topic has 2 replies, 1 voice, and was last updated 9 years, 10 months ago by
community-content.
-
AuthorPosts
-
-
June 26, 2008 at 1:10 AM #19993
Hello, As our prod environment has grown in load, we are intending to replace the existing single quad core based sql server nodes with high end servers. The existing 2 sql nodes are in active/passive cluster configuration.
the 2 new nodes will replace the existing nodes behind the same VIP in the cluster. all the dbs are on san and are presented to the active node.
Can we take a db backup from the existing server and restore it onto the new server and everything will be fine?Is there any extra steps that need to be undertaken? Has anyone done this before and would share his experiences? thanks
Regards,
-
June 26, 2008 at 3:27 AM #19994
Never done an in-place SQL Server swap before, but it should work. Are the new servers going to be exact copies of the originals, OS, SQL Server – same service packs, and hotfixes?
Be sure to turn off the Biztalk Servers (either power down or stop the host instances and IIS), and SQL Agent before you backup the databases.
The last time I moved Biztalk SQL databases, we installed a new server with a new name/IP. Stopped Biztalk, IIS and SQL agent, backed up the databases, copied and restored on new server and ran the 2 scripts in C:\Program Files\Microsoft BizTalk Server 2006\Schema\Restore http://technet.microsoft.com/en-us/library/aa559835.aspx
In your case you shouldn’t need to jump thru these hoops.-
June 26, 2008 at 8:12 PM #20008
hello greg,
thanks for the response..
yeah the new servers are going to be exact copies.I remember last time,in a small test environment, we had to rename our sqlnode(no cluster here); after that we reconfigured the BTSAdmin on the Biztalk nodes to pick up the new name for the server hosting the Mgmt db. We could never get Biztalk working post that.
I now wonder if it was because we did not run the 2 scripts??
we had un-installed and re-installed Biztalk then and then all the BTS applications.regards,
-
-
-
AuthorPosts
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.