even with compression it still does take up a certain amount of space.

Thanks for your help folks.

Thanks Grant - I will take the stats out

I tested that command this afternoon on a TLog 65 GB 95% Log usage. Took 5 mins 30secs...

Clustering uses shared storage which we have had problems with in the past. We are trying to move away from that. Ha was a project requirement and after costs for...

Thanks for your reply .

This was one option I was considering running after a daily insert into the DW tables

BACKUP LOG [databaseName]

TO DISK = 'nul:' WITH STATS = 10

My...