blog community
Sign in
|
Join
|
Help
Home
Blogs
Media
Bertrand Rohrbock
»
All Tags
»
SQL Agent
(
RSS
)
Browse by Tags
Bertrand Rohrbock
Home
Syndication
RSS for Posts
Atom
RSS for Comments
Email Notifications
Go
Recent Posts
Detecting if DTC is running
Restoring MSDB across instances, a bad idea
Tags
Clustering
Datafiles
Errorlog
Introduction
Migration
Red Gate SQL Backup Pro
SQL 2000
SQL 2005
SQL Agent
View more
Archives
March 2008 (1)
January 2008 (1)
November 2007 (2)
October 2007 (2)
September 2007 (3)
Clustering
Errorlog
Migration
SQL 2000
SQL 2005
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...
Published
14-03-2008 11:35
by
BertrandR
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...
Published
14-11-2007 9:22
by
BertrandR
Filed under:
Clustering
,
SQL 2005
,
Errorlog
,
Migration
,
SQL Agent