Want to archive old partition data.

[Dominique Karg]

Hello everybody,

I'm pretty new to all of this partitioning stuff but I must say I'm excited at the foreseeable performance improvements this provides.

I got an application which stores vast amounts of events (mainly security but also generic / compliance log events) into a table. The event viewer that works on this table by default works on the entire table, with no key, date or whatever limitations.

Therefore, until I can implement some other limitations I'd like to move partitions older than, let's say, 30 days away into a backup table.
I already started coding everything using merge tables but this seems much faster/better/easier.

Is this possible ? Which would be the best way to accomplish this ? (thinking fo an event that would backup old data using insert into ... select * from after creating partitions in the backup table).

Sorry if this or something similar has been covered before, been checking the forums and googling for partitions the whole day and couldn't find a satisfying answer.

TYIA for any help.