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
Monday, February 20, 2012
New Database
Labels:
configured,
database,
databases,
drives,
files,
log,
microsoft,
mssql,
mysql,
oracle,
separate,
server,
sql,
user_db_data,
user_db_logs
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment