Sanjay Thakur-488205 (10/23/2013)
Kindly advice the same How to remove/ Delete Transaction Log from SQL Server 2008 R2. as previously we are using SQL Server 2000 Detach database and remove log file then attach. But in SQL Server 2008 R2 not able to do the same.
Short answer. Don't.
The transaction log is not an optional part of the database, it's critical and it's what ensures transactional and structural integrity. Deleting the log could easily result in a database that's transactionally inconsistent, structurally inconsistent or completely unusable.
Deleting a log is one of the worst things you can do to a database
http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/
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