I have a 23GB database MDF and 1GB database LDF located in E:\SQLServer.
I understand that if I shift my LDF file to another hard disk, eg. D:, the performance might be slightly faster.
I tried to detach the database and delete the LDF file. When I reattach the MDF, SQL2000 will re-create the LDF file back in E:\SQLServer, but I wish to move the LDF file to D:\, which is another hard disk. How do I do this?