Moving transaction log files to another drive

Originally the database on this server was set up so that the data and the t
ransaction log files were on the same drive, now I want to move the transact
ion log files to another drive on the same server. Can anyone tell me if th
is can be done and how? Th
anks in advance!
Message posted via http://www.droptable.comEasiest is most probably sp_detach_db, copy the file, sp_attach_db (specifyi
ng the new location for
the log file), verify all ok, delete the original log file. And, of course,
a database backup first.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"SHEILA ROSCOE via droptable.com" <forum@.droptable.com> wrote in message
news:15a5e29bb5934836a7a979b030b98e00@.SQ
droptable.com...
> Originally the database on this server was set up so that the data and the
transaction log files
> were on the same drive, now I want to move the transaction log files to an
other drive on the same
> server. Can anyone tell me if this can be done and how? Thanks in advanc
e!
> --
> Message posted via http://www.droptable.com