Skip to content

Instantly share code, notes, and snippets.

@aswad32

aswad32/moving-tempdb-sqlserver.sql

Last active December 20, 2016 23:29
Show Gist options
  • Save aswad32/1eae86f89c26313b1d43373c0e61b51f to your computer and use it in GitHub Desktop.
Save aswad32/1eae86f89c26313b1d43373c0e61b51f to your computer and use it in GitHub Desktop.
Download ZIP
Moving SQL Server tempdb to another drive
Raw
moving-tempdb-sqlserver.sql
use master
go
alter database tempdb modify file (Name=tempdev, filename='D:\SQLServer\tempdb.mdf')
go
alter database tempdb modify file (Name=templog, filename='D:\SQLServer\templog.ldf')
go
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment