Moving tempdb

13 Jan 2006 3:31 PM

Emma

How do I move tempdb to another drive on the same server?

Thanks
Emma

13 Jan 2006 3:33 PM

Ryan

The syntax is :- ALTER DATABASE tempdb MODIFY FILE ...

INF: Moving SQL Server Databases to a New Location with Detach/Attach
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q224071

--
HTH. Ryan

Show quote

"Emma" <E***@discussions.microsoft.com> wrote in message
news:A653420A-D77D-4DD5-B041-94B70D9D205E@microsoft.com...
> How do I move tempdb to another drive on the same server?
>
> Thanks
> Emma

13 Jan 2006 3:38 PM

Emma

Please ignore this message. Found the information at http://support.microsoft.com/default.aspx?scid=kb;en-us;224071#XSLTH3207121122120121120120

Thanks

Show quote

"Emma" wrote:

> How do I move tempdb to another drive on the same server?
>
> Thanks
> Emma