Tag: MSSQL 2012 R2

• 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