Hi Jef and Gila,

Now I understand why I shouldn't shrink the Data file, I will take 'Shrink Database' Off from Maintenance Plan. All information you guys posted are very useful. Thanks.

I got another query, on my production server, all the transaction log files are very big, about 45GB but initial size is 4GB. My question is, shall I shrink the transaction log ONLY so that Log not gow too much. Shall I do that every night?

I never backup the transaction log even database model is -FULL. transaction log backup is not required for my environment at the moment.

if you suggest to do that, 'Before' or 'After' my Maintenance Plan?

*****

BACKUP LOG t_log_name WITH TRUNCATE_ONLY

DBCC SHRINKFILE (t_log_name,amount,retain )

*****

Sat

<<=== Here ?

1.Check DB Integrity [All Database]

2.Rebuild Index [Expect System Database]

3.Backup Database [All Database]

4.Clean Up Maintenance Plan

5.Clean Up History

<<== Here?

Thanks