BP DB Archiving

[SeeAnnLoh]

Does anyone has experience to create DB archive script to transfer entire data from BP database to another database?

------------------------------
SeeAnn Loh
Senior Programmer
Jabil
Asia/Kuala_Lumpur
------------------------------

[John__Carter]

It would be easier to take a back up of the original DB and restore it in the new SQL instance.

------------------------------
John Carter
Professional Services
Blue Prism
------------------------------

[MayankGoyal2]

@John Carter - Kindly suggest the steps for the backup if anything specific to be taken care of from BP perspective. Also kindly suggest what is the procedure of clearing logs beyond a certain date in BP (ex only keep process and objects log of last one year and delete rest) in case we have to free up some memory. Is there any documentation or guide on the same? ​Will this clear logs from work queue item and session manager as well, are all these sections referring the logs from same storage? 
Also I assume WQ items and session manager execution entries wont be cleared with clearing logs, just that on checking logs it will show blank once cleared?

------------------------------
Mayank Goyal
------------------------------

[MayankGoyal2]

@John Carter - Kindly have a look at above and suggest.

------------------------------
Mayank Goyal
------------------------------

[anand060191]

Hi John,

Kindly help with the steps. Also please elaborate the points mentioned by @Mayank Goyal

Regards,
Anand Singh

------------------------------
Anand Singh
------------------------------

[John__Carter]

Backing up and restoring a DB is something your DBA team can advise on - there's nothing specific to BP about doing that. Depending on what kind of migration you are doing, it may be useful to back up BP config files for use in a new environment (and of course in case of rollback).

Session logs can be archived or deleted using the BP client (System > Settings > Archiving). Work queues are not affected by session log archiving. Old queue items must be managed either manually or via a simple housekeeping process (using the work queue VBO). Managing logs, queues and any other data generated or used by a process is something to consider in the solution design, and maintenance is best done 'a little and often' rather than trying an infrequent bulk operation. The definition of 'old' is something you need to agree with the Business process owners and document as part of a general Archive and Backup Policy.

In the event of problems, the support team can also provide DB housekeeping SQL scripts on request.

------------------------------
John Carter
Professional Services
Blue Prism
------------------------------