Monday, February 20, 2012

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 ?Enterprise Manager
..Right-click on server
...Click on Properties
...Database Settings tab
....Set Default data directory and Default log directory

No comments:

Post a Comment