0

What is the difference in terms of I/O disk usage between Simple Backup and Full Backup?

Does full backup incur more reads and writes?

How does full backup mode impact reads and writes to TempDB's transaction log?

closed as unclear what you're asking by Erik Darling, Joe Obbish, hot2use, mustaccio, Philᵀᴹ Nov 25 '18 at 14:52

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • Are you trying to understand the recovery model or the different types of backups possible? tempdb is a unique case in sqlserver in that it supports all other databases on the instance and is considered ephemeral with regards to the recovery model. – Aaron Nov 23 '18 at 3:24
0

Microsoft recommends setting it to SIMPLE to limit space utilisation. See here. From an IO perspective, SIMPLE mode will generally require the same IO because it has to retain enough transaction data to facilitate rollback of an active transaction. There is some good information on TLOG utilisation here.

Not the answer you're looking for? Browse other questions tagged or ask your own question.