Sessions: 181 The postings on this site are my own and do not represent my Employer's positions, advice or strategies.

LifeAsBob

  Monday, December 30, 2024
Wider View Login

Cluster
DOS
IBM - AS400
MOM
Performance Counters
Service Broker
SQL Server
     Temporary Database
          TempDB Monitoring an...
          Moving the tempdb da...
          TempDB Multiple File...
          Moving the Temporary...
     Views
     Backup
     SQL Mail
     DTS - Data Transformation Services
     Memory
     Security
     Excel
     Jobs SQL Agent
     MSDE
     Install
     DBCC
     User Management
     System Databases
     BCV
     Deadlocks
     Temp Tables
Windows OS




Will be added as a sub-category of, Temporary Database
Moving the Temporary Database

Commands to move the temporary database are....

 -- move tempdb

-- requires shutdown and restart...

alter database tempdb modify file (name='tempdev', filename='F:\MSSQL\Data\tempDB.MDF')

alter database tempdb modify file (name='templog', filename= 'F:\MSSQL\Data\TempDB.LDF')

**After restart, you can delete old tempdb files.**