Category Archives: MSSQL 2008 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 … 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