|
||||||
|
Here’s the script I metioned a few days ago. I wrote this a while back (Pre-RC0, I think). Anyway, if you’ve got a bunch of servers that you need to perform a common task on (copy files, check event logs, etc), this is handy…however, it only works if you’ve got the Managed By field set in AD. [...] No. This script doesn’t do the updates for you, as awesome as that would be. I have a bunch of boxes that I have to do firmware updates on tonight. Apparently the Dell PERC4 has an issue on a certain firmware revision that will cause arrays of 5 or more disks in RAID 5 or 50 [...] So, for whatever reason you need to move your BizTalk databases from one SQL server to another. In my case, I was moving from a hostname to a CNAME, for DR purposes (failover server is in another DC, and not clustered). In the event of a disaster, we could just fail over to the other database server, change the CNAME to point to the “failover” server, and we should be back up and running. The problem, I found, was changing from DC1BTSQL1 to the CNAME (we’ll call it BTSQL1). After searching for a while (maybe I’m an idiot, but all of these things were classified as “backup and restore methods” not “I’m changing server name” methods or anything like that) I found two scripts and an xml file. Under %systemdrive%\Program Files\Microsoft Biztalk Server 2006\Schema\Restore are two VBS scripts. UpdateDatabase.vbs and UpdateRegistry.vbs. There’s also an XML file called “SampleUpdateInfo.xml.” Below is the procedure for changing the SQL server name. You can even change the names of the DBs. This procudure assumes you’ve backed up and restored, or attached, the DBs to the “new” server already. Continue reading Moving Microsoft BizTalk Server 2006 Databases to a new SQL Server So, here it is. My “IT Stuff” blog. Here, I’ll pretend to be a writer AND pretend to know what I’m talking about…maybe I can help some people out along the way. By trade, I’m a server engineer…specifically Microsoft products ranging from Server 2003, SQL Server 2005, BizTalk Server 2006, IIS, and more. PowerShell rocks. I find myself writing [...] |
||||||
|
Copyright © 2010 PhishThis! - All Rights Reserved |
||||||
