Category: 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 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