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

LifeAsBob

  Thursday, July 19, 2018

 


Home
Blog
bob tech
Calendar
Contact Bob
Pictures
VW Buses
HomeBrew
Cook Book

 

EJH August 2007 School Pa

  bob Links
4GuysFromRolla.com -...
For when the lepers she nursed implored her for beer and there was none to be had, she changed the water which was used for the bath into an excellent beer, by the sheer strength of her blessing, and dealt it out to the thirsty in plenty. - From the Life os St. Brigid
Wider View Insert

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

Insert Category

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.**