The Multifunctioning DBA:



September 26, 2011  1:27 PM

Another DR Test

Posted by: Colin Smith
DR, testing

So we have what sounds to be a great idea for our SQL Server DR. We are doing block level replication between datacenters and so we thought it might be a good idea to joust mount up our disk on another server that is in the DR Datacenter in case of a disaster. We want to do that with the disk that...

September 23, 2011  1:32 PM

DR SQL Server Memory Test

Posted by: Colin Smith
DR, memory, Settings

My new company has a DR Test coming up and we came up with a great idea on how to make the SQL Servers test pretty simple. We use SAN Block level replication so we should be able to mount up our shared disk to any server that has the correct version of SQL Server installed. One question that we had...

June 22, 2011  8:23 PM

Fail over Mirror database with Powershell

Posted by: Colin Smith
DR, Mirror, Mirror Fail over, Powershell

Today I was asked if I could help out by writing a simple script that would fail over a mirrored database from one server to the other and back if and when needed. I thought sure I can. I mean to do the failover with T-SQL is really simple but I can automate it. So here is the T-SQL to fail...

January 28, 2011  2:11 AM

Disabled SA account

Posted by: Colin Smith
DBA, DR, enable sa, sqlhelp

I recently had a situation where something happened to my SQL Server and I could no longer log in using windows authentication. I will get more into what happened in another post. Let me just preface all this by saying that I inherited this mess. Anyway, thanks to

January 26, 2011  8:00 AM

What is DR??

Posted by: Colin Smith
DR, Planning, Recovery

What is DR? How do you define it? I would really like to know. Please put your thoughts in the comments but a recent event has made me re-think what DR truly is. I have a SQL Server that is very mission critical and if the database is not up and accessible the company is losing money. This is...

February 23, 2010  9:46 PM

MSDB Problems

Posted by: Colin Smith
corruption, DBA, DR, On-Call, Planning, SQL Administration

Just the other morning at 3:00 AM I get a page, Love being on call, and I see some errors about MSDB. Well this concerns me but it is 3:00 AM and my head is not really on straight. I doze back to sleep, in ten more minutes I get two pages, This time I get errors about MSDB again and I also get...

September 23, 2009  4:52 PM

Oracle Dataguard Replication Scare

Posted by: Colin Smith
Dataguard, DBA, DR, Oracle, Oracle Administration, Standby Database

I had to bring down the standby server for the power outage in our DR location a few nights agon. No big deal, shut off replication from the primary, go to the standby and do a shutdown imediate, since you can not do a shutdown on the standby server. When things cam up I go to the secondary and do...

September 22, 2009  4:55 PM

Sybase Instance Scare

Posted by: Colin Smith
DR, Sybase, Sybase Administration

Monday morning my company was putting in a new UPS at our DR facility. This is great but it means that all database instances that are running at that location are coming down as power to the entire site was down for 2 hours. No big deal right, I got a list of the instances and shut them all down...


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: