Why can't I set tempdb full recovery?

When I try to set it , I get the error Option 'RECOVERY' can't be set in database 'tempdb'
ITeedOffAsked:
Who is Participating?
 
dwkorConnect With a Mentor Commented:
TempDB is internal sql server database and always use the simple recovery. SQL recreates it during every restart so it's good idea to set the appropriate initial size. You can read more here: http://msdn.microsoft.com/en-us/library/ms190768.aspx
0
 
chapmandewCommented:
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?
0
 
ITeedOffAuthor Commented:
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
0
All Courses

From novice to tech pro — start learning today.