Skip to content

Instantly share code, notes, and snippets.

@ersingencturk

ersingencturk/new_gist_file.sql

Created January 3, 2015 02:09
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save ersingencturk/7bf636cbb1ea778bb8a3 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save ersingencturk/7bf636cbb1ea778bb8a3 to your computer and use it in GitHub Desktop.
Download ZIP
moving sql server temp file to another disk
Raw
new_gist_file.sql
USE master;
GO
ALTER DATABASE tempdb
MODIFY FILE
(NAME = tempdev, FILENAME = 'D:\sql\Tempdb.mdf');
GO
ALTER DATABASE tempdb
MODIFY FILE
(NAME = templog, FILENAME = 'D:\sql\Tempdb.ldf');
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment