Post reply

Basic SQL ''05 setup/config question: How do I change the data file location?

  • May 12, 2006 at 12:15 pm

    #168930

    I want to keep my log files on C and the data files on the D drive for example...how do I do this? Is this different in '05?

    Thanks!

  • May 14, 2006 at 2:35 pm

    #637749

    If you mean the default data and log file settings, that hasn't really changed.  You just need to right-click on the server instance in object explorer, go to properties, go to the Database Settings tab, and change the settings. 

    The move of existing data files is pretty well documented.  In Books Online 2005, go to the following link:

    ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/89f01b10-5fae-4ed8-b0fb-a4b9f540fd28.htm

    Pay attention to the resource database piece, as there is no parallel in SQL Server 2000.

    Derrick Leggett
    Mean Old DBA
    When life gives you a lemon, fire the DBA.

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

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