Move tempdb files to a new disk

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Jack (jacka8_at_excite.com)
Date: 03/16/04 

Date: Tue, 16 Mar 2004 14:33:23 -0800

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

  • 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)
  • Re: Database would not auto grow
    ... If you increase the size of the data file manually with "alter database ... does the file grow and consume the 18GB of free disk ...
    (microsoft.public.sqlserver.server)