Is this correct: If I have a database in SIMPLE recovery mode, can I assume the ROLL forward/back is shorter, because MSSQL is only checking the uncommited transactions? All other (committed) logrecords are unusable, because these actually don't exist in the logfile (as a result of the SIMPLE recovery mode) And, if I have FULL recovery: Is MSSQL checking the whole logfile in case of a FULL recoverymode? thus making the roll-forward/-back longer?
I assume we're talking about a RESTORE operation. And the short answer is, no, SIMPLE won't speed things up at all. When a backup starts, it gets a marker from the transaction log so that it knows what all the uncommitted transactions are. Then it runs. Then it gets all the transactions that committed or rolled back during it's operation. That is the only information that is used for recovery during the restore operation. It doesn't matter if the database is in FULL or SIMPLE, the backup and restore processes are the same.