• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 239
  • Last Modified:

Help with an error on MS SQL server 2008

I am trying to change the recovery model from simple to full in the tempdb on a SQL 2008 server that I just setup and I am getting the attached error. I want to find how to go about doing that for data backup purposes and find out if this is going to impact any other database on this server by making this change.
1 Solution
The simple recovery model is required; therefore, tempdb log space is always automatically reclaimed. You cannot backup tempdb.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now