Bertrand Rohrbock

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

Problems starting the SQL Backup Agent service

Sometimes one or more of our backup proceses hang and when this happens the SQL Backup Agent service needs to be restarted in addition to the process being killed on the server. However for some reason (my thesis is that this happens when you do not kill...

Published 09-01-2008 8:57 by BertrandR

Filed under: Red Gate SQL Backup Pro

Moving datafiles, the easy way

Sunday morning (I love maintenance windows) I had to move some datafiles that were placed incorrectly. I thought this would be an easy job. Detach, move the files and reattach, right ? Wrong. It appears that SQL Server won't release handles on the...

Published 19-11-2007 10:39 by BertrandR

Filed under: SQL 2005, Datafiles

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

Reporting version number on SQL Backup Pro

Just a quick update to share a piece of handy information. Red Gate does not document it in their help files, but there is a way to get the version number of the Red Gate DLL used to create backups with T-SQL with the following query: DECLARE @version...

Published 26-10-2007 13:51 by BertrandR

Filed under: Red Gate SQL Backup Pro

Reading the SQL errorlog

Yesterday I was doing an analysis of the SQL errorlog in response to a cluster node that had been crashing frequently. First I noticed there's a rather annoying bug in SQL Server Management Studio: if you press the filter button before all the log...

Published 25-10-2007 9:56 by BertrandR

Filed under: SQL 2005, SQL 2000, Errorlog

Object references and SQL

While it might seem strange or even impossible to work with objects in SQL it is possible. I stumbled upon this recently while I was investigating a way to automatically drop and recreate indexes on a SQL 2000 server. DECLARE @object INT EXEC sp_OACreate...

Published 25-09-2007 14:04 by BertrandR

Writing better SQL scripts

Many organisations that have a platform for application hosting that includes different environments for development, testing and production use SQL scripts to migrate between environments. As a DBA I see a lot of these scripts and a lot of them are written...

Published 13-09-2007 14:19 by BertrandR

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

Published 11-09-2007 9:09 by BertrandR

Filed under: Clustering, SQL 2005, Introduction

Syndication

Recent Posts

Tags

Archives