Specify SQL2005 LogFiles Path on Install

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • johnmeola@gmail.com
    #1

    Specify SQL2005 LogFiles Path on Install

    Any assistance is appreciated.

    I would like to know if there is a way to specify the path for database
    log files to be located during the SQL2005 Standard installation.
    Under the Advanced button there is the ability to specify a different
    path for data files but nothing for logs.

    Thanks in advance,
    John

    Tags: None
    • Erland Sommarskog
      #2
      Re: Specify SQL2005 LogFiles Path on Install

      (johnmeola@gmai l.com) writes:
      I would like to know if there is a way to specify the path for database
      log files to be located during the SQL2005 Standard installation.
      Under the Advanced button there is the ability to specify a different
      path for data files but nothing for logs.
      That setting includes the log files, as far as I know.

      Once you have installed you can set the default location for database
      files and log files separately from Management Studio.


      --
      Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

      Books Online for SQL Server 2005 at
      http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

      Books Online for SQL Server 2000 at
      http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

        Comment

        • John
          #3
          Re: Specify SQL2005 LogFiles Path on Install

          Understood and thanks for the quick reply.

          But, what if I want the data files on one volume and the logs on
          another?

          I know I can do this afterwards by detaching, moving and reattaching.

          But I would like to do it during the install.



          Erland Sommarskog wrote:
          (johnmeola@gmai l.com) writes:
          I would like to know if there is a way to specify the path for database
          log files to be located during the SQL2005 Standard installation.
          Under the Advanced button there is the ability to specify a different
          path for data files but nothing for logs.
          >
          That setting includes the log files, as far as I know.
          >
          Once you have installed you can set the default location for database
          files and log files separately from Management Studio.
          >
          >
          --
          Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se
          >
          Books Online for SQL Server 2005 at
          http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

          Books Online for SQL Server 2000 at
          http://www.microsoft.com/sql/prodinf...ons/books.mspx

            Comment

            • John
              #4
              Re: Specify SQL2005 LogFiles Path on Install

              Understood and thanks for the quick reply.

              But, what if I want the data files on one volume and the logs on
              another?

              I know I can do this afterwards by detaching, moving and reattaching.

              But I would like to do it during the install.



              Erland Sommarskog wrote:
              (johnmeola@gmai l.com) writes:
              I would like to know if there is a way to specify the path for database
              log files to be located during the SQL2005 Standard installation.
              Under the Advanced button there is the ability to specify a different
              path for data files but nothing for logs.
              >
              That setting includes the log files, as far as I know.
              >
              Once you have installed you can set the default location for database
              files and log files separately from Management Studio.
              >
              >
              --
              Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se
              >
              Books Online for SQL Server 2005 at
              http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

              Books Online for SQL Server 2000 at
              http://www.microsoft.com/sql/prodinf...ons/books.mspx

                Comment

                • Erland Sommarskog
                  #5
                  Re: Specify SQL2005 LogFiles Path on Install

                  John (johnmeola@gmai l.com) writes:
                  Understood and thanks for the quick reply.
                  >
                  But, what if I want the data files on one volume and the logs on
                  another?
                  >
                  I know I can do this afterwards by detaching, moving and reattaching.
                  Yeah, but the only file you would be interested in moving is the tempdb
                  log. There is little reason to put the log files for the other system
                  databases on a separate disk.

                  --
                  Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

                  Books Online for SQL Server 2005 at
                  http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

                  Books Online for SQL Server 2000 at
                  http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

                    Comment

                    • John
                      #6
                      Re: Specify SQL2005 LogFiles Path on Install

                      Good point.

                      Thanks again :)

                      Erland Sommarskog wrote:
                      John (johnmeola@gmai l.com) writes:
                      Understood and thanks for the quick reply.

                      But, what if I want the data files on one volume and the logs on
                      another?

                      I know I can do this afterwards by detaching, moving and reattaching.
                      >
                      Yeah, but the only file you would be interested in moving is the tempdb
                      log. There is little reason to put the log files for the other system
                      databases on a separate disk.
                      >
                      --
                      Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se
                      >
                      Books Online for SQL Server 2005 at
                      http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

                      Books Online for SQL Server 2000 at
                      http://www.microsoft.com/sql/prodinf...ons/books.mspx

                        Comment

                        Previous template Next
                        Working...