How to restore Team Calendar in Conflulence v3.3

[Prasad]

Hi team,

1. One of our user accidentially deleted calendar from confluence.

How can we restore it?

2. How do I get list of all calendar from SQL table?

[Marcelo Horlle]

Hey Prasad,

Whenever you delete an entire calendar, Confluence is supposed to send an email with a backup file to anyone subscribed to that calendar. You can later use this file to restore the calendar if necessary.

Regarding the SQL Table, Calendar information is stored at ao_950dc3_tc... Table. You can select distincted name Calendars from this table to get the needed list. Just remember to bring Confluence offline if you are going to modify anything through SQL on this given table, although it is not recommended and supported. The select queries should be fine without shutting down the application.

[Prasad]

Thank you Marcelo for answer.