• @Festeron: Nope - the log backup containing the minimally-logged operation cannot be used for a STOPAT restore to any point in time covered by the entire log backup. For this reason, it makes to stay in BULK_LOGGED for as little time as possible and to bracket that time with log backups. You can restore (using a sequence of log backups) to any point before the start or after the end of that log backup, but not during it.

    Edit: Yes, you can see if a backup contains minimally-logged operations. In the output from RESTORE HEADERONLY, look for the HasBulkLoggedData column being 1, and in the backupset table in msdb, look for the has_bulk_logged_data field being 1.

    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