I recently install SQL2005 on my win 2003 server. I have 3 drives (C, D, E). The sql is installed on D.
When I install SharePoint, it create the database for me. However, both data & log files are default to D:\Program files......
As advised, I should separate data & log files into different drives. How can I set the default data file to D and log file to E? Can I detach the model database and move the current ldf file to E. Then update the new location when
I reattach the model database? Will this change my future default log file location? Is this save to do it this way? or I shouldn't touch the model database. Instead, do a manual change after a new database is created?!
View Complete Post