** Quickly Shrinking the Transaction Log – Database Journal

Quickly Shrinking the Transaction Log – Database Journal: "Quickly Shrinking the Transaction Log
By Krishnan Kaniappan

In this article I would like to discuss about the following two things:
1) About shrinking the transaction log.
2) Different ways of taking the database offline."

Can use the SQL Management Studio to perform the following operations

1) Detach the database file (.mdb)
2) Delete the transaction log file (.ldb) - by going into the file system (Path: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data)
3) Attach the db file (.mdb) - at this point remove the log file which is refered over the screen.