<div>
Because nothing in tempdb can ever be recovered...it is dropped and recreated each time sql server is restarted. &nbsp;why would you want to set it to full recovery?
</div>


Because nothing in tempdb can ever be recovered...it is dropped and recreated each time sql server is restarted.  why would you want to set it to full recovery?

<div>
My Barracuda Backup agent won't do incremental backups if it sees any database that is not set to full. I was able to set the Master, Model and MSDB<br />
and all of my user databases. Hopefully, the agent will ignore the tempdb
</div>


My Barracuda Backup agent won't do incremental backups if it sees any database that is not set to full. I was able to set the Master, Model and MSDB
and all of my user databases. Hopefully, the agent will ignore the tempdb

<div>
<div class="content wysiwyg-content">
When I try to set it , I get the error Option 'RECOVERY' can't be set in database 'tempdb'
</div>
</div>


When I try to set it , I get the error Option 'RECOVERY' can't be set in database 'tempdb'

Why can't I set tempdb full recovery?

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.