>>I am working on a new installation. The company DBA sent me email with directions where to install (attach) my database. It looks like she created two folders, one for mdf and another for .ldf. Her email says "Make sure to use default file directory for DB install (E:\AppName\data and E:\AppName\log"
>>
>>Do I understand correctly that she wants the mdf and ldf to be placed in two different directories? Why would they use this approach?
>>
>>TIA
>
>Found this recent article that confirms it's still being considered a best practice
>
>
http://sqlmag.com/storage/sql-server-storage-best-practices>
>See also
>
>
https://msdn.microsoft.com/en-us/library/bb402876.aspx>
>and this nice presentation by Jes Borland
>
>
http://www.brentozar.com/archive/2012/09/how-sql-server-works-log-file-video/Did you read all these articles before you suggested them to me? :)
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham