Move the TEMPDB Database

USE master
GO

ALTER DATABASE tempdb

MODIFY FILE

(NAME = N‘tempdev’,

FILENAME = N‘C:\Tempdb\tempdb.mdf’ ,

SIZE = 1024,

FILEGROWTH = 256)

GO

ALTER DATABASE tempdb

MODIFY FILE

(NAME = N‘templog’,

FILENAME = N‘C:\TempDB\tempdb.ldf’ ,

SIZE = 1024,

FILEGROWTH = 512)

Go

Then restart SQL Server and delete the old tempdb files.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: