Structure-Retaining Database Copy or Restore on Windows

If the database is on several drives on Windows, problems occur as follows:

• Database copy with retained structure, that is, backup_dev_type = disk_copy | disk_standby | stage_copy | stage_standby)

  BRBACKUP attempts to copy all databases onto the drive which is defined in the init<DBSID>.sap parameter new_db_home.

• Restore on another computer with changed database name:

  BRRESTORE attempts to reload all databases to the drive which is defined in the environment variable SAPDATA_HOME.

In both cases the distribution of the database files to several drives is not maintained.

For more information about solving this problem, see SAP Note 122363 .