Dump log and move log to another drive

Hi,
I am getting a message that my transaction log is full. After looking at
the drive where it is located, I only have 8 megs left on that drive which
is pretty bad! I would like to do two things. Dump the log and then move
it to another larger drive. I am using SQL 2005 on Windows 2000 Server.
Thanks in advance,
Will
Will Dupleich,
Backup the transaction log and use "alter database ... modify file ..." to
move the log to a new drive.
Troubleshooting a Full Transaction Log (Error 9002)
http://msdn2.microsoft.com/en-us/library/ms175495.aspx
AMB
"Will Dupleich" wrote:

> Hi,
> I am getting a message that my transaction log is full. After looking at
> the drive where it is located, I only have 8 megs left on that drive which
> is pretty bad! I would like to do two things. Dump the log and then move
> it to another larger drive. I am using SQL 2005 on Windows 2000 Server.
> Thanks in advance,
> Will
>
>
|||Hello,
1. Do the Trasnaction log backup
2. Detach the database [SP_DETACH_DB DBname>
3. Copy/Move the LDF file to new disk/drive
4. Attach the database with new drive letter to LDF file [SP_ATTACH_DB
dbname,'MDF name with path','Ldf name with new path'
FYI, This steps require some downtime...
You can also do it ONLINE by creating a new LDF file in new drive using
ALTER DATABASE command or from SQL Server management studio.
Thanks
Hari
"Will Dupleich" <will@.getdynamic.com> wrote in message
news:Oghm22udHHA.4868@.TK2MSFTNGP06.phx.gbl...
> Hi,
> I am getting a message that my transaction log is full. After looking at
> the drive where it is located, I only have 8 megs left on that drive which
> is pretty bad! I would like to do two things. Dump the log and then move
> it to another larger drive. I am using SQL 2005 on Windows 2000 Server.
> Thanks in advance,
> Will
>