Solved

Help with an error on MS SQL server 2008

Posted on 2011-09-15
1
212 Views
Last Modified: 2012-05-12
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.
SQL2008-Error.jpg
0
Comment
Question by:TonyEF
1 Comment
 
LVL 17

Accepted Solution

by:
dbaSQL earned 500 total points
ID: 36544928
The simple recovery model is required; therefore, tempdb log space is always automatically reclaimed. You cannot backup tempdb.
http://msdn.microsoft.com/en-us/library/ms365937.aspx

0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
how to import 7 54
SQL Query Syntax Error 9 34
How to generate total number of records in db 35 27
Update in Sql 7 12
     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now