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

Revisions

  1. aswad32 renamed this gist Dec 20, 2016. 1 changed file with 0 additions and 0 deletions.
    0 moving-tempdb-sqlserver.txt → moving-tempdb-sqlserver.sql
    View file
    File renamed without changes.
  2. aswad32 renamed this gist Dec 20, 2016. 1 changed file with 0 additions and 0 deletions.
    0 gistfile1.txt → moving-tempdb-sqlserver.txt
    View file
    File renamed without changes.
  3. aswad32 revised this gist Dec 20, 2016. No changes.
  4. aswad32 created this gist Dec 20, 2016.
    6 changes: 6 additions & 0 deletions gistfile1.txt
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,6 @@
    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