Hi

is this a good practice if I shrink the database files and
its log files after each day's full backup? Is this a
good practice for data warehouse databases?

many thanks.

JJ

I cannot say whether its a good practise or not. But I can
say some disadvantages.

1. During the ETL process, the data file log file grows
accordingly.
If you truncate daily, then everyday during the ETL
process, the data file & log has to grow accordingly which
increases the sql server tasks, since it has to allocate
extents/pages every day, which makes the load process slow.
Basically the data/log files which are made to increase
by % or by some constant value has to keep growing
everyday. This consumes lot of disk acitivity, IO,
processes too.

-Varad

>-----Original Message-----
>Hi
>
>is this a good practice if I shrink the database files
and
>its log files after each day's full backup? Is this a
>good practice for data warehouse databases?
>
>many thanks.
>
>JJ
>.
>