Restore CMS DB

[#1]

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