the queue didn´t change much:

queue_messages_1165247206queue_clustered_index466621046500404589950364543632835858

queue_messages_1165247206queue_secondary_index990909908397677774774763

How can it be reduce?

Regards,

Juan

We run:

sp_updatestats

;

and then:

dbcc shrinkfile (1,100)

;

dbcc shrinkfile (2,100)

;

and it dropped to 37 GB

Still we do not know why is so big... any advice will be welcome.

Thanks.

But the thing is that we have been doing that for a year....:blink:

The databases restored fine and I found out that we had 3 databases sharing the same data files....