Tempdb recommendations

[Danne]

By default, the tempdb database is created in the same location as the master, model and msdb. The tempdb is used to store temporary objects. Each time SQL Server is started all the objects in tempdb are deleted but the file sizes are retained.

Does Symantec have any guidelines about the size of the tempdb,
our tempdb is approx. 7GB and still growing,
We are using EV2007 SP1, we are not using DA,
I could not find any recommendations in the documentation.


Many Thanks,
//Dan

[TonySterling]

Is that the data file or the transaction log that is growing?

[Ryan_the_Red]

You might be able to truncate the transaction log by running a backup of the tempdb transaction log.

You could simplify matters by setting tempdb to the simple recovery model and just running a full tempdb database backup but that said, your tempdb database would not be recoverable to a point in time later than the last database backup (i.e. by replaying transaction logs).

I have a dedicated SQL Server for Enterprise Vault, and I run full backups of all databases and either an incremental or full vault store and indexing backup after each archiving run. So, I usually set the simple recovery model and accept that I will not be able to restore transaction logs after the last full database backup.

[Danne]

Thanks for your replies,
It’s the data file that’s growing,