Afficher un message
Vieux 12/09/2006, 00h13   #5
Warren Brunk
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Re: SQL Server 2000 - Default path for data files

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
>



  Réponse avec citation
 
Page generated in 0,05625 seconds with 9 queries