Simple way would be to :
1.Detach the database using sp_detach_db. [requires that no user is
accessing the database and also database would be offline till you attach it
2.Move the .ldf file to desired location.
3.Attach the database back using sp_attach_db , this time mentioning the new
SQL Server FAQ at
"John" <ab.com> wrote in message