How to Move an SAP BusinessObjects BI Platform System Database and Audit Database

How to Move an SAP BusinessObjects BI Platform System Database and Audit Database

Technology Used

  • SAP BusinessObjects BI Platform 4.1 (this includes SAP BusinessObjects Enterprise 4.1, SAP BusinessObjects Edge 4.1 and SAP Crystal Server 2013)
  • Microsoft SQL Server 2008 R2
  • Microsoft SQL Server 2012

Background

Our Support Team at DSCallards is regularly asked how to move the SAP BusinessObjects BI Platform 4.1 Central Management System (CMS) database and Auditing database.

The Central Management System (CMS) database is the database that sits behind the SAP BusinessObjects BI Platform 4.1 application. It has information about users, groups, Filestore locations of Business Intelligence content stored within the application, and plays a critical part of the platform.

The Audit database stores usage and activity related to the SAP BusinessObjects BI Platform 4.1 system, with information such as who logs on, who runs what reports and when and more.

I thought I would share the steps I took to do this.

Download PDF

Posted By Rebecca Middleton, Senior BI Consultant on November 30th,2015