Category Archives: 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 … Continue reading

Posted in Cluster Disk, Cluster Shared Volume, CSV, Hyper-v 2012 R2, ISCSI Initiator, MSSQL 2012, Powershell 4.0 | Tagged , , , , , , , , , , | Leave a comment

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 … Continue reading

Posted in Database Replication, Microsoft SQL Server, MSSQL 2000, MSSQL 2008 R2, MSSQL 2012, Publisher, Replication Agents, Subscriber, Transactional Replication | Tagged , , , , , , , , , , , , , , | 2 Comments

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 … Continue reading

Posted in MSSQL 2008 R2, MSSQL 2012 | Tagged , , | Leave a comment