I would like to move my server TempDB file from F: to J:
drive. What are the steps to complete this tasks?
Thank You,
TimSee "Moving Tempdb" in this article:
http://support.microsoft.com/defaul...kb;en-us;224071
David Portas
SQL Server MVP
--|||Hi,
USE master
go
ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev, FILENAME =
'J:\tempdb.mdf')
go
ALTER DATABASE tempdb MODIFY FILE (NAME = templog, FILENAME =
'J:\templog.ldf')
go
where NAME refers to the logical name of the tempdb database and
log files, and where FILENAME refers to the new location of the
tempdb files. Once this command has run, you must restart the
mssqlserver service before it takes affect.
Thanks
Hari
MCDBA
"Tim" <anonymous@.discussions.microsoft.com> wrote in message
news:116c201c3f4ac$1e7d8280$a501280a@.phx
.gbl...
>
> I would like to move my server TempDB file from F: to J:
> drive. What are the steps to complete this tasks?
> Thank You,
> Tim
Showing posts with label jdrive. Show all posts
Showing posts with label jdrive. Show all posts
Subscribe to:
Posts (Atom)