Post reply

SQL Server database location changes

  • November 14, 2011 at 8:47 am

    #246058

    For a particular SQL Server 2008 R2 instance, in the database settings, the location for the data and log files are mentioned as below

    G:\MSSQL10.MSSQLSQLSERVER\MSSQL\Data

    G:\MSSQL10.MSSQLSQLSERVER\MSSQL\log

    But actually, the database data and log files are residing in the following location

    S:\MSSQL10.MSSQLSQLSERVER\MSSQL\Data

    S:\MSSQL10.MSSQLSQLSERVER\MSSQL\log

    So, when a new database is going to get created from the application end, am sure it goes to G Drive.

    Are there any ill effects in that?

    Or can I change the database settings to point to S Drive? I believe this needs a reboot?

    Would there be any changes in the server settings which will corrupt my server?

  • November 14, 2011 at 8:57 am

    #1407251

    You can change the defaults and restart SQL Server to take effect. However, there are no issues with having the files located somewhere other than the defaults.

    Thanks,

    Jared

    Jared
    CE - Microsoft

  • November 14, 2011 at 8:59 am

    #1407253

    jared-709193 (11/14/2011)

    You can change the defaults and restart SQL Server to take effect. However, there are no issues with having the files located somewhere other than the defaults.

    Thanks,

    Jared

    we dont have any files in the default location..

    So,I guess its risk free.

  • November 14, 2011 at 9:01 am

    #1407259

    It can be annoying to have to change the location every time you restore or create a new database. That's about it. Also, if you have no files in the current default location DO NOT delete the folders until the default location is changed. SQL Server looks for the existence of these folders on startup and will not be able to start if the default folder locations are not found. I learned this the hard way 🙂

    Thanks,

    Jared

    Jared
    CE - Microsoft

  • November 16, 2011 at 7:38 am

    #1408518

    I changed the location of database settings from G Drive to T Drive.

    Does this need a recycle of SQL Server?

    I dont think so, because, when I tried to create a new database, its by default going on the new T Drive

  • November 16, 2011 at 9:10 am

    #1408667

    itsamarnath (11/16/2011)

    I changed the location of database settings from G Drive to T Drive.

    Does this need a recycle of SQL Server?

    I dont think so, because, when I tried to create a new database, its by default going on the new T Drive

    If it is doing what you want, no need to restart.

    Thanks,

    Jared

    Jared
    CE - Microsoft

Viewing 6 posts - 1 through 5 (of 5 total)

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