moving transaction logs in sql 2000

Hi
We have a mission critical database above which we have a crm application
that sits on top of it. In trying to improve the performance of the sql
database I have added another logical disk which is in actual fact another
raid 1 array. I would like to move the transaction log files to this new
logical drive but keep the .mdf data files on the original logical volume.
What is the best way of getting the transaction log to this new location?
Would it be to create another filegroup? Or would it be a better idea to
drop and create the database once again but this time in creating it
configure the transaction logs to be on the new physical\logical drive then
restore the data and objects from the most recent backup ?
Your assistance is appreciated.-sp_detach_db
-File Copy
-sp_attach_db
Make sure having a valid backup if something breaks in between
HTH, jens Suessmeyer|||Fazz
> that sits on top of it. In trying to improve the performance of the sql
> database
I'd suggest you to identify first a long running queries or stored
procedures and try to improve them , by adding/droping indexes
,investigations an execution plan and......
The thing is that poor performane is result of bad/poor running queries or
an application design or a database design rather than a hardware problems
"Fazz" <farayi@.lovetm.co.uk> wrote in message
news:uL$JCWyJGHA.532@.TK2MSFTNGP15.phx.gbl...
> Hi
> We have a mission critical database above which we have a crm application
> that sits on top of it. In trying to improve the performance of the sql
> database I have added another logical disk which is in actual fact another
> raid 1 array. I would like to move the transaction log files to this new
> logical drive but keep the .mdf data files on the original logical volume.
> What is the best way of getting the transaction log to this new location?
> Would it be to create another filegroup? Or would it be a better idea to
> drop and create the database once again but this time in creating it
> configure the transaction logs to be on the new physical\logical drive
> then restore the data and objects from the most recent backup ?
> Your assistance is appreciated.
>