jboc (5/27/2009)
On occasion a log file will fill up to the problem point and we could use detach/attach to delete the old log and start over. Not something that we would normally want to do but something that was an option in an emergency. Is there a simple way to do that once detach/attach goes away?
This should never be used as an option. It is essentially ripping the transactional heart out of your database. Despite being successful doing this numerous times in the past, it only takes once for the disasterous effects of doing this to ruin your day, job, career when the database fails to attach without its log.
I'd recommend reading Paul Randal's article:
http://technet.microsoft.com/en-us/magazine/cc895648.aspx
and his blog posts on the Transaction Log:
http://sqlskills.com/BLOGS/PAUL/category/Transaction-Log.aspx
Specifically:
When you attach without the log file, it is rebuilt, which can leave your database incosistent, not a good thing to do.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]