Category: MSSQL 2012

• Resolving Cluster Shared Volume “Redirected Access Mode” Error.

  A while ago, I encountered a Cluster Shared Volume error in my lab. I logged into the Failover Cluster Manager and noticed multiple error status messages in the Cluster Events log. The System Log Event ID 5125 kept showing up every three minutes: Error Event id 5125 with details: Cluster Shared Volume ‘Volume1’ (‘Cluster Disk…

  jbernec

  February 9, 2015

  Cluster Disk, Cluster Shared Volume, CSV, Hyper-v 2012 R2, ISCSI Initiator, MSSQL 2012, Powershell 4.0

  Cluster Shared Volume, Clusters, CSV, Failover Cluster Manager, Filter Driver, Hyper-v Cluster, ISCSI, iscsi initiator, Powershell 3.0, Redirected Access Mode, Windows Server 2012 R2

• Configuring Transactional Replication between MSSQL 2000 and MSSQL 2012 Databases Part 1

  Microsoft® describes replication as a set of solutions that allow you to copy, distribute, and potentially modify data across your enterprise. Simply put it’s involves a mechanism that makes it possible to synchronize data across multiple database copies in any enterprise. We’ve been running MSSQL 2000 replication for a while now to isolate our Reporting…

  jbernec

  August 19, 2014

  Database Replication, Microsoft SQL Server, MSSQL 2000, MSSQL 2008 R2, MSSQL 2012, Publisher, Replication Agents, Subscriber, Transactional Replication

  Articles, Database Replication, Distributor, Enterprise Manager, Log Reader Agent, Microsoft SQL Server, MSSQL 2000, MSSQL 2008 R2, MSSQL 2012, Publication, Publisher, SQL Management Studio, Subscriber, Subscription, Transactional Replication

• Moving TempDB Database Files on MSSQL 2012 R2.

  I ran into a disk space situation on a new database server and decided to move the Tempdb files to a new drive location. My first thought was to detach the database and move the files. It turns out you can’t detach a tempdb database since it’s a system database. The following T-SQL query helped…

  jbernec

  June 16, 2014

  MSSQL 2008 R2, MSSQL 2012

  MSSQL 2008 R2, MSSQL 2012 R2, Transact-SQL