Saturday, September 18, 2010

Moving? Tempdb is out of space

Moving Tempdb

In order to move the tempdb database, open SSMS and run the following query:

use master
go
Alter database tempdb modify file
(name = tempdev, filename = 'E:\Sqldata\tempdb.mdf')
go
Alter database tempdb modify file
(name = templog, filename = 'E:\Sqldata\templog.ldf')
Go

This command assumes that you are
moving the database files to E:\Sqldata directory

No comments:

Post a Comment