Does anyone know if it is possible to restore a backup of an OLAP database to another database without bring the system down for a MT-Cloud implementation?
There might be times on a production system that you want to recover some data without bringing down the system. With on-premise this is straight forward where you can restore a backup to another database, review its data, and then make a decision on the next action.
With MT-Cloud, I can only see an option to restore the database. So the steps would be:
- Take the system offline (not sure how I would do this but that is a another matter)
- Backup the database
- Restore the desired backup
- Export the database
- Restore the more recent backup
- Bring the system online
- Create another application and import the database from step 4
It isn't ideal to have a system outage so I was wondering if there is a better way.
