blog community

Browse by Tags

• Errorlog
• Introduction
• Migration
• SQL 2000
• SQL Agent

• Detecting if DTC is running

  I've recently worked on a fix for one of our jobs that starts when the SQL agent is started and proceeds to contact a central server to report the new node the instance is running on. The problem is that sometimes the MSDTC isn't running when Read More... Posted Friday, March 14, 2008 11:35 AM by BertrandR | 0 Comments Filed under: Clustering, SQL 2005, SQL 2000, SQL Agent

• Restoring MSDB across instances, a bad idea

  We've recently been migrating instances of SQL Server between different clusters in order to dismantle an old cluster. To move the jobs we've been copying the MSDB from the old instance to the new one by performing a restore and we didn't Read More... Posted Wednesday, November 14, 2007 9:22 AM by BertrandR | 15 Comments Filed under: Clustering, SQL 2005, Errorlog, Migration, SQL Agent

• Installing multiple instances of SQL server without rebooting

  Figured I'd make my first post not just an introduction, but also give some usefull information on SQL cluster installations that isn't documented very well. Let's start with the introduction. I am Bertrand Rohrbock, 25 years old and working Read More... Posted Tuesday, September 11, 2007 9:09 AM by BertrandR | 8 Comments Filed under: Clustering, SQL 2005, Introduction