Question Re: Restore CMS DB in Technology Q&A

Restore CMS DB

Former Member — Thu, 29 Sep 2016 07:14:56 GMT

Hi,

I have CMS DB backup and Filestore backup in 4.1 SP3. I will use them in new server and need to bring reports and universes vs.

Should I restore CMS log files to new server, too? I don't want to do it because its size 192 GB.

Best Regards,

Cihangir,

Re: Restore CMS DB

Former Member — Thu, 29 Sep 2016 08:19:52 GMT

There is no need to restore the log files from another environment. Your new environment will have its own logs.

Re: Restore CMS DB

Former Member — Thu, 29 Sep 2016 08:22:59 GMT

Hi Kuldeep,

Is it enough to copy paste CMS.db Files to new server?

Best Regards,

Cihangir

Re: Restore CMS DB

Former Member — Thu, 29 Sep 2016 08:29:43 GMT

Hi Cihangir,

Along with the CMS Database, the FileStore should also be copied to the destination environment.

Take a backup of the CMS database.

Also, refer to KBA #1275068 below :

https://service.sap.com/sap/support/notes/1275068

Regards,

Sharvari

Re: Restore CMS DB

Former Member — Thu, 29 Sep 2016 08:30:45 GMT

What do you mean by copy CMS.db to the new server? Which database are you using for CMS daatabase for eg. oracle, DB2, etc.

There is a standard procedure to restore the database. Have a look at this blog:

https://launchpad.support.sap.com/#/notes/0001275068

Re: Restore CMS DB

CdnConnection — Thu, 29 Sep 2016 11:45:37 GMT

Cihangir,

If you have back-up copies of the CMS & FRS then I the perfect step-by-step to help you, see below

Regards,

Ajay

Re: Restore CMS DB

Former Member — Thu, 29 Sep 2016 12:04:46 GMT

Hi Ajay,

I have a big problem. I don't have CMS DB password. Can I import CMS DB without knowing DB password?

Best Regards,

Cihangir

Re: Restore CMS DB

Former Member — Thu, 29 Sep 2016 12:22:42 GMT

Yes. You can ask your DBA to reset the password. Once reset, while connecting to CMS DB, use the new password.

Re: Restore CMS DB

CdnConnection — Thu, 29 Sep 2016 13:04:19 GMT

Cihangir,

Not a problem, you will need to connect to the database and reset the password for ID=12.

See below KB showing you the steps

https://launchpad.support.sap.com/#/notes/0001679970

Regards,

Ajay

Re: Restore CMS DB

Former Member — Thu, 29 Sep 2016 13:22:28 GMT

Hi Ajay,

I need to learn or delete CMS Database password. Document you sent is related administrator password.

Is there any way to import CMS db without password? How can I? Our db is Sybase anywhere on the BO server and we don't have DB admin related with it. Is there any other user in Sybase to enter the system? .

Best Regards,

Cihangir

Re: Restore CMS DB

Former Member — Thu, 29 Sep 2016 13:31:17 GMT

Google it and check , how to reset the password for Sybase.

Re: Restore CMS DB

CdnConnection — Fri, 30 Sep 2016 00:57:24 GMT

Cihangir,

As mention by Jawahar, just google how to.

Here is link to Sybase help

SyBooks Online

Regards,

Ajay