|
Home > Archive > MS SQL Server OLAP > December 2005 > database and flex aggregates
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
database and flex aggregates
|
|
|
| Hey,
I Restart the server and my main database which was 40gb is now only 20gb.
i have tha the date for browsing and all seems ok,
but when i looked at the data directory and compare the files from my last
backup
i can see that there are some missing files.
most of the agg.flex.map are just gone...
need your help to understand this issue
Best Regards,
Chai.
| |
| Akshai Mirchandani [MS] 2005-12-28, 3:24 am |
| Did you re-design aggregations or incrementally process a dimension?
Probably some similar operation cleared the flexible aggregations and/or
indexes and they were being built lazily in the background when you
looked...
Aggs may be built lazily in the background -- although there is now a DSO
option to synchronously rebuild aggs/indexes at the time of processing
(ProcessFullReaggreg
ate).
See:
http://blogs.msdn.com/bi_systems/articles/187701.aspx
and
http://www.microsoft.com/technet/pr...n/ansvcspg.mspx
Thanks,
Akshai
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.
"Chai" <Chai@discussions.microsoft.com> wrote in message
news:ABD53723-52A0-46AC-96D4- 03C51736BEF7@microso
ft.com...
> Hey,
>
> I Restart the server and my main database which was 40gb is now only 20gb.
> i have tha the date for browsing and all seems ok,
> but when i looked at the data directory and compare the files from my last
> backup
> i can see that there are some missing files.
> most of the agg.flex.map are just gone...
> need your help to understand this issue
>
> Best Regards,
> Chai.
|
|
|
|
|