SQLUSA

Microsoft SQL Server 2000 Best Practices

How to shrink the transaction log quickly?

 

The following procedure will solve the problem of an overgrown transaction log file quickly:

1. Place the database into single user mode.

2. Detach the database using sp_detach_db procedure.

3. Rename the log file. Delete it at a later point.

4. Attach the database using sp_attach_db procedure.


The World Leader in SQL Server Training
 
SQLUSA.com Home Page