Post reply

regarding tempdb log file in sql server2005

  • December 18, 2008 at 3:25 am

    #195237

    hi,

    where we can find tempdb log file in sql server2005.

    thanks in advance,

    cheers,

    ram.

  • December 18, 2008 at 4:33 am

    #914395

    Default location is C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA

    Branch down System Databases, Right click tempdb > Properties

    Select Files and confirm the default location there.

    For I/O performance it is wise to place your tempdb on a drive with less activity.

    Hope this answers your question

  • December 18, 2008 at 6:46 am

    #914484

    Run the following code

    use tempdb

    go

    exec sp_helpfile

    [font="Verdana"]Markus Bohse[/font]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply