• Correction: ATTACH_REBUILD_LOG will only create a single log file, no matter how many log files you had before.

    Beware that in all cases, you get a 0.5MB log file with two 0.25MB VLFs.

    Paul Randal
    CEO, SQLskills.com: Check out SQLskills online training!
    Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
    SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
    Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005