How to backup database and operating system

[Former Member]

Hello gurus, I am new to sap basis. I really need your guideline and help in regards to the issue that i am facing now. Right now in my server have 2 instances. One of the instance will be ECC 6.0 IDES & BW 7 which is running on Windows Server 2003 32bit operating system & MSSQL Server 2005.

My Ultimate task is to uninstall both of these instances from this server and also the operating system. Then I need install 64bit operating system and Solution Manager 7 on that server. Before I uninstall the ECC6.0 and BW7 i need to backup those database and also the sap operating system files. Can anyone guide me step by step how to do this please. I really would appreciate a prompt reply. Thank you.

[Former Member · Accepted solution]

Hi Pavan,

I mean such files as USR> TRANS>BIN--> All those sap files .... when we install sap all this files install together in sap right. Do we need backup all these files in the operating system level. Next time when we need the same system can we use all those thing ?

I also have this problem when connecting to the Microsoft SQL Studio,,....

Cannot open user default database. Loging Failed.

Login Failed for user BFSAP7\ig7adm ; (Microsoft SQL Server , Error :4064)

[Former Member · Accepted solution]

Yes its must if you need all the developments which you have done and want to be there in the future system also . Make sure you release all the transports and back up the co files and data files from the os level.

and you dont need these files for installing the system, you need them only when you want the particular development or data in the transport to be there in the system for use in the system which you are building.

please check the Note 806925 - SQL Error 4064: Cannot open user default database

Regards,

Pavan

[Former Member · Accepted solution]

Hi Ram,

Take o/s backup using tool NTBACKUP and select all files and folder.Here you will be able to store all database and other data also.

Regards

Ashok Dalai

[Former Member]

Its very easy to do a back up in MSSQL , everything is clearly available on a right click of the database in the server studio. Once you have a complete offline backup you can go ahead and completely format the system as you can build a new system from the available backup.

after the backup completely format the system since its of no use uninstalling sap as the operating system is also going to change.

I am unable to get what do you mean by SAP operating system files...?

Regards,

Pavan