Moving Transaction logs

I am running a SQL Server and want to move the transaction logs of all the
databases to another disk. I detached one of the databases, moved the
transaction log file to another disk and then tried to re-attach the databas
e
-- specifying the new log file. But I got an error.
How should I move the transaction logs ?
Thanks,
CraigDetach and attach is generally considered to be the best way to move databas
e files. You need to be
more specific about what you did and the error you got if you want help. Her
e's a script showing
create, detach, copy file, delete original file and attach:
CREATE DATABASE test_db
ON PRIMARY
( NAME = a,
FILENAME = N'c:\a.mdf',
SIZE = 1MB,
MAXSIZE = 200MB,
FILEGROWTH = 10%)
LOG ON
( NAME = l,
FILENAME = N'c:\l.ldf',
SIZE = 512KB,
MAXSIZE = 200MB,
FILEGROWTH = 10%)
GO
EXEC sp_detach_db test_db
EXEC master..xp_cmdshell 'copy c:\l.ldf c:\temp\l.ldf'
EXEC master..xp_cmdshell 'del c:\l.ldf'
EXEC sp_attach_db 'test_db', 'c:\a.mdf', 'c:\temp\l.ldf'
EXEC test_db..sp_helpfile
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Craig HB" <CraigHB@.discussions.microsoft.com> wrote in message
news:3D7FC130-4CA5-4B54-AD04-491AF0F79CB1@.microsoft.com...
>I am running a SQL Server and want to move the transaction logs of all the
> databases to another disk. I detached one of the databases, moved the
> transaction log file to another disk and then tried to re-attach the datab
ase
> -- specifying the new log file. But I got an error.
> How should I move the transaction logs ?
> Thanks,
> Craig|||That code you posted worked -- thanks for that.
- Craig