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