Restore CMS DB

[Former Member]

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,

[CdnConnection]

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

[Former Member]

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

[Former Member]

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

[CdnConnection]

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

[Former Member]

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

[Former Member]

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

[CdnConnection]

Cihangir,

    As mention by Jawahar, just google how to.

Here is link to Sybase help

SyBooks Online

Regards,

Ajay

[Former Member]

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

[Former Member]

Hi Kuldeep,

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

Best Regards,

Cihangir

[Former Member]

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

[Former Member]

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