Thanks for the question.
I agree that both options may be correct, depending if the database was shut down cleanly AND only one log file existed for the database file. BOL specifies:
- "If multiple log files exist, they must all be available."
- "If a read/write database has a single log file that is currently unavailable, and if the database was shut down with no users or open transactions before the attach operation, FOR ATTACH automatically rebuilds the log file and updates the primary file."
in the FOR_ATTACH option.
"A watt of Ottawa" - Gerardo Galvan
To better understand your help request, please follow these best practices.[/url]