Create a backup database

It is recommended that you take a backup of your OLTP source database along with the history data as required (typically, 2 years) before you go live with Business Intelligence. Restore this backup into a different database and use this to perform initial data load.

For more information about taking a backup and restoring your database, refer to your database vendor documentation.