Tag: 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…
-
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…