1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice

default location of new MSSQL databases?

Discussion in 'Plesk for Windows - 8.x and Older' started by section9, Mar 23, 2005.

  1. section9

    section9 Guest

    0
     
    When I use the CP to add a new MS SQL database for a specific domain, Im wondering if there is somewhere I can change the default location that the database file is stored?
     
  2. RCorbet

    RCorbet Guest

    0
     
    It's possible to change the default location of where MSSQL stores its databases from inside MSSQL itself.

    1. Open Enterprise Manager.
    2. Expand the tree to find the server that you want to change the default location of databases for.
    3. Right click on the server name and select properties.
    4. Select the database settings tab.
    5. At the bottom of this page you can set the default data and log directories that the database files will be created under.
    6. You will probabyl need to restart SQL server for the changes to take efect.

    HTH

    Roland
     
Loading...