Backing up TempDB and Templog.ldf

I have just noticed our tempdb is way too big.  I am going to fix this, but I need to know if we need to be backing up our tempdb (I don't think so) and templog.ldf?  Tempdb is around 5 gigs big.
r270baAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
chapmandewConnect With a Mentor Commented:
You don't really need to back it up too often...as the data is cleared out when the db server restarts.  I would make sure there aren't too many open temp tables and uncommitted transactions....try shrinking the file and truncating the log.
0
 
digital_thoughtsConnect With a Mentor Commented:
Whic file is larger the .mdf (database file) or .ldf (log file)? If its the log file, it may help to do a backup, but probably won't help with the underlying problem, check out this article: http://www.sql-server-performance.com/faq/tempdb_large_p1.aspx
0
 
r270baAuthor Commented:
Sorry for the delayed reply.  

So I have changed the autogrow (I think) to a max size of 500MB for the mdf file and left the ldf file with no restrictions.  Is this correct?

Also, do I actually NEED to be backing this up?
0
 
chapmandewConnect With a Mentor Commented:
No need to back it up.
0
All Courses

From novice to tech pro — start learning today.