Move Logs to another drive

Does anyone know how to move the SQL logs to another drive. I want to
seperate these from the database for redundancy and performance
I get an error stating the log cannot be moved after the database has been
create.
SQL 2000 STD
Thanks in advance for your helpSee sp_detach/ sp_attach in BOL.
"Bob Smith" <BobSmith@.discussions.microsoft.com> wrote in message
news:D14C7D37-BCF5-4D79-ACCE-95C1F75C4783@.microsoft.com...
> Does anyone know how to move the SQL logs to another drive. I want to
> seperate these from the database for redundancy and performance
> I get an error stating the log cannot be moved after the database has been
> create.
> SQL 2000 STD
> Thanks in advance for your help|||"Bob Smith" <BobSmith@.discussions.microsoft.com> wrote in message
news:D14C7D37-BCF5-4D79-ACCE-95C1F75C4783@.microsoft.com...
> Does anyone know how to move the SQL logs to another drive. I want to
> seperate these from the database for redundancy and performance
> I get an error stating the log cannot be moved after the database has been
> create.
> SQL 2000 STD
> Thanks in advance for your help
sp_attach_db and sp_detach_db can help you here.
Alternately, you could issue a RESTORE DATABASE command specify the new
location using the MOVE TO option.
Rick Sawtell
MCT, MCSD, MCDBA