Forum Discussion

KeirL's avatar
KeirL
Level 6
13 years ago
Solved

EV Partition Rollover

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 

  • 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?

  • 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