Re: Move tempdb files to a new disk

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 03/16/04 

Date: Tue, 16 Mar 2004 23:42:01 +0100

You do this using ALTER DATABASE. See KB 224071 for more info. 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Jack" <jacka8@excite.com> wrote in message
news:e4a401c40ba6$b1358d50$a301280a@phx.gbl...
>
> I have done a new installation which is up and running.
> However the disk on which the tempdb mdf and ldf files are
> is giving a problem. Is there a way to move the files to a
> different disk? I know we can't detach and attach it.
> Alter database does not allow the primary data file to be
> deleted.
>
> I can create a new data file on the other disk and stop
> the existing datafile from growing. This will effectively
> move all tempdb activity to the new disk. But is there no
> better way to move the mdf and ldf files to the new disk?
>
> TIA,
> Jack

Relevant Pages

  • Re: Defragmenter no longer works.
    ... This is not correct, Jack. ... Over time any disk that's used for write operations will become fragmented. ... Defrag still doesn't work. ... Chkdsk cannot run because ...
    (microsoft.public.windows.mediacenter)
  • Does any one recognize this binary data storage format
    ... We are working on a data file reader and extraction tool for an old ... Hex On Disk: C0DBA8ECF441 ...
    (comp.lang.python)
  • Re: Help! Help
    ... I cannot export/import or access the data file. ... i tried to rin the original disk to fic the files but it sees the disk as a ... the original install disk is a patch! ...
    (microsoft.public.office.misc)
  • File Handling and Caching
    ... There are data files used to store the logical data records ... records in the data file. ... if I want to be able to prevent unnecessary disk reads by implementing ... this "cache" functionality myself or utilize the win32 memory mapped file ...
    (microsoft.public.vc.mfc)
  • File Handling and Caching
    ... There are data files used to store the logical data records ... records in the data file. ... if I want to be able to prevent unnecessary disk reads by implementing ... this "cache" functionality myself or utilize the win32 memory mapped file ...
    (microsoft.public.vc.language)