SQL Server Performance


Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by rtatom, May 15, 2006.

  1. rtatom New Member

    Hi, just installing Microsoft SQL2005 onto a server. We are wanting to install so that the database is located on one partition and the transaction logs are on a different partition. Is there a place where I can change the default location of transaction logs files' locations? Any help would be great & thanks in advance.[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]
  2. Luis Martin Moderator

    I can't follow you.

    If you want to install master, mdsdb, tempdb, you can do it in custom/expert mode.

    Now if you want to create databases, then you can choose where log files goes.

    More, if allready you have databases, you can use Alter Database to change location.


    Luis Martin

    Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
    Leonardo Da Vinci

    Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte

    All postings are provided “AS IS” with no warranties for accuracy.

  3. derrickleggett New Member

    You can also change the default location by going into the Management Studio, right-clicking on the instance name in the object explorer, going to properties, selecting the database settings and putting in a default.


    When life gives you a lemon, fire the DBA.

Share This Page