haiao2000 (4/30/2013)
The last question he asked was if he can delete the LDF file and still be able to reattach the database. I told him he could, but extremely cautious and back it up before delete it permanently. I sent him query to reattach db without LDF file and that was last time I heard from him =)
I do hope he had a backup, because if you detach a DB that's got a completely full log file and then delete the transaction log, the chances are better than average that you won't be able to reattach (there wasn't space in the log for SQL to do a clean shut down) and that you'll need to fetch out a database backup and restore it.
That's why the first thing I said in this thread was "Do Not Delete the log file"
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