Best Case Scenario you should have two seperate physical drives and even
better case those drives should be ran using seperate controllers. The cost
of puting the database files onto a UNC path is much worse then keeping the
log files and db files on the same drive.
If you have storage size issues I suggest that you back up and checkpoint
the transaction log often to keep the size of it low.
--
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/
"Frank Goris" <FrankGoris@discussions.microsoft.com> wrote in message
news:6CA1DC73-EA17-4BA1-BE0D-D2CFDC555C06@microsoft.com...
> Thanks Sue for the reply !
>
> I understand it is not "Best Practice".
> Try to work out something else.
> Just wanted to avoid to store the log file on the same drive as the data
> files.
> If you (or anybody else) has an idea, please feel free to reply
>
> Best regards,
> Frank
>