Solved

Help with an error on MS SQL server 2008

Posted on 2011-09-15
1
219 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL server 2008 and after encryption method 32 62
date diff with Fiscal Calendar 4 54
MS SQL Update query with connected table data 3 38
Re-appearing SQL Server Agent jobs 7 29
     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 …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

856 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