Why do you need to shrink the log?
Please read through this - Managing Transaction Logs[/url]
Minaz Amin (2/27/2007)
1. Backup the transaction log.2. Shrink it.
3 Create a maintenanace plan to do the backup regularly.
Create the maint plan to back the log up regularly. Shrinking the log on a regular basis is not recommended
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability