Transaction Logs!!!!

[07974]

I have found out that it is best practice to put transaction logs onto a seperate physical disk than the database files. I'm running SQL 2000 and was wondering exactly when I am supposed to place the transaction log files onto the seperate physical disk, because once they are created on the disk with the database files I am told they cannot be moved... can anyone help?!!?

 

[sunaj]

http://www.microsoft.com/sql/using/tips/administration/movingtransactionlogs.asp

Sunaj
'The gap between theory and practice is not as wide in theory as it is in practice'

 

[07974]

Cheers Sunaj, looks quite helpfull... no doubt I'll be adding another post if I still can't do it.

 

[tlbroadbent]

You will want to review the following if moving the master database log.
[ignore]

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q224071

[/ignore] Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.