Perry Whittle (1/11/2012)
To re attach a database with a missing log file just use either
sp_attach_single_file_db
CREATE DATABASE .... FOR ATTACH_REBUILD_LOG
Which only works if the database was shut down cleanly before the log was deleted, not in all cases.
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