Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Nebraska SQL from @DBA_ANDY

I'm a forty-something Microsoft SQL Server DBA of 12+ years, a devoted husband, and a father of two young boys (with another coming soon!). I have been a DBA at a university, at a major bank, at a healthcare system, and I now work as a consultant with customers across the United States.

Archives: April 2014

Why Can't I Reinitialize My Subscriber?



I recently had a colleague request help with a replication problem he was having with a client.  The client was running transactional replication from a SQL Server 2005 Publisher to multiple SQL Server 2005 Subscribers and was having issues after attempting to add several articles (tables) to an existing publication.

Read more

1 comments, 299 reads

Posted in Nebraska SQL from @DBA_ANDY on 28 April 2014

Where are my 32-bit Perfmon Counters?

I have run into this before, but not in this same way, so I decided it would be worth writing about.

On a client server they are running 32-bit SQL Server 2005 (I know, not supported - that's a different rant/post) on a 64-bit Windows 2008 installation.  When I logged…

Read more

2 comments, 779 reads

Posted in Nebraska SQL from @DBA_ANDY on 23 April 2014

Why does my Failover Cluster Instance Keep Failing Back and Forth?

A few months ago I was paged by a client because their SQL Server Failover Cluster Instance (FCI) was experiencing multiple failovers when they performed routine Windows patching.

The client's request which generated the work ticket was this:

At some point recently this clustered node failed over from the A…

Read more

1 comments, 1,152 reads

Posted in Nebraska SQL from @DBA_ANDY on 17 April 2014

I Know I Shouldn't Shrink My Log file, BUT...

As a managed services DBA, I frequently have to clean up after other people's mistakes. (Come to think of it, as *any* DBA you spend time cleaning up other people's mistakes...)

We all know you shouldn't shrink your log file (right?  We all know this, right?) The experts constantly preach…

Read more

4 comments, 1,026 reads

Posted in Nebraska SQL from @DBA_ANDY on 3 April 2014