Link to home
Start Free TrialLog in
Avatar of r270ba
r270ba

asked on

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.
ASKER CERTIFIED SOLUTION
Avatar of chapmandew
chapmandew
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of r270ba
r270ba

ASKER

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?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial