Re: Move tempdb files to a new disk

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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: Big Ol BLT
    ... And disk space is something you can never have ... Thanks for the info, Jack. ... but if this is so common to do, perhaps I should find a different shop to work on mine. ... There's a free software product called "XXclone" that will clone your HDD, then you can swap the cloned drive for the old one and see if it works while you still have the original drive to swap back if it doesnt. ...
    (rec.food.cooking)
  • 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)
  • Re: Big Ol BLT
    ... And disk space is something you can never have ... computer shop doesn't have at least one of those lying around for their ... own use - letting them do it would be your preferred option. ... Thanks for the info, Jack. ...
    (rec.food.cooking)
  • 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)