Paul,

You're right there's no need to shrink the tempdb. I was just using that as an example. Obviously you need to change the database and log file name...

True, but that's why you backup the log file every so often during the day...

Jim

Here's a query that I use to shrink the log file and the database:

--Shrinks a database Manually

sp_dboption 'temp', 'trunc. log on chkpt.', 'TRUE'--Set a checkpoint

use tempdb checkpoint--Declare the checkpoint

go

--Shrink the...