12-06-2012 04:46 AM
Hi
Can anyone tell me if I set a partition to rollover based on time (eg 6 Months) when this time starts from? I assume this is when the partition moves to an 'Open' status but would like confirmation please
Here is an example to explain a little better -
I have an Open partition which I create on 1st Jan 2012 and I set this to rollover after 6 months (I'm not using the option where I can set a specific date)
I have a second partition which I also create on 1st Jan 2012 which is 'Ready' and this too has a rollover set to 6 months
I create a third partition which I set to 'Closed' again on the 1st Jan 2012 and again set it to a 6 months rollover
When the 6 months elapse my 'Open' partition closes and my Ready partition becomes Open - In my mind the 6 months of the newly opened partition starts from this point??
If it's done on creation date then this partition will rollover straight away as it was initially created on the 1st Jan 2012
Anytime in the following 6 months I can set my previously 'closed' partition to 'Ready' and this will sit there until 1st jan 2013 when my currently Open partition will rollover.
Hope this makes sense.
Kind regards
KL
Solved! Go to Solution.
12-06-2012 06:46 AM
it is definitely from the time it is opened
12-06-2012 06:27 AM
Hi,
Interesting question. I would assume the time starts counting the moment the partition is opened. Otherwise in your example, the partitions would open, and then close immediately.
A simple solution would be to set the rollover for the second partition to 12 months, but I am not sure that is the real solution.
Is you 2nd partition still open?
12-06-2012 06:46 AM
it is definitely from the time it is opened
12-06-2012 06:52 AM
And for what it's worth, EV stores the dates in the PartitionEntry table and has these three columns
TimeCreated: 2012-01-01 12:00:00.000
TimeOpened: 2012-06-01 12:00:00.000
TimeClosed: 1900-01-01 00:00:00.000
So based on that, if i had 6 months, it would roll over in December 2012, even though it was created on January 1st
12-06-2012 07:20 AM
JW is spot on, that are the entrys I was looking for too.
12-06-2012 07:57 AM
Thanks both