Results 1 to 2 of 2

Thread: New Database

  1. #1
    Join Date
    Apr 2004
    Location
    Melbourne
    Posts
    144

    Smile Unanswered: New Database

    I've configured my data and log files for SQL Server Databases on separate drives.

    D:\MSSQL\Data\User_db_data\
    E:\MSSQL\Log\User_db_logs\

    however, everytime i create a new database it defaults to the old location. How can i create a database using enterprise manager to default to the new locations ?

  2. #2
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    Enterprise Manager
    ..Right-click on server
    ...Click on Properties
    ....Database Settings tab
    .....Set Default data directory and Default log directory
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •