SQL Server Performance

tempdb help

Discussion in 'Getting Started' started by lara99, Nov 28, 2007.

  1. lara99 New Member

    HI all
    1.hi guys how to put the tempdb on its seperate drive as the database is already created.how to change the path.
    Thanks in advance.
  2. FrankKalis Moderator

    Check out the explanations to ALTER DATABASE in BOL. Under example G: you will find how to move tempdb to a new location.
  3. anandchatterjee New Member

    Try this sample!!
    use master
    Alter database tempdb modify file (name = tempdev, filename = 'E:Sqldata empdb.mdf')
    Alter database tempdb modify file (name = templog, filename = 'E:Sqldata emplog.ldf')

Share This Page