how to add a backup device

[Former Member]

Hi all,

I am planing to take a backup for my XI PRD server on an external hard drive which is connected directly to the XI PRD sever via a USB cable.

Now my question where should we define it so that when we want to take a backup thru DB13 it should show my external HDD.... for the backup

Can anyone help me do this please, its urgent for us...

I am not sure where do we define the devices...

We are running SQL server 2005 on WIN 2003 server, ECC 6.0

waiting to hear more from you.

Thanks and regards

Hari

[MichaelTe]

Hello Hari,

you can do this this way:

Define the backup medium in the SQL Server Enterprise Manager.

<u>SQL Server Enterprise Manager:</u>

- Open the Enterprise Manager

- Navigate to your installation, probably: (local) (Windows NT)

- In the left menu tree goto: Management -> Backup

- Right click in the right window and select: New Backup Device

- Enter the correct path to your Filename on the external HDD

Regards, Michael

[Former Member]

Hello Sir,

I am really Sorry to mistype the DB, the DB is not SQL it is Oracle, can you please help me out with this..

Millions thanks for the quick responce...

I request you to treat this as an urgent requirement... plz

Waiting to hear from you...

Thanks

Hari Haran.V

[MichaelTe]

Hello Hari,

sorry for the late answer.

I don't know Oracle that much, but I think you must define a

backup_dev_type = disk

in the file init<DBSID>.sap stored in directory <ORACLE_HOME>/dbs (UNIX)

or <ORACLE_HOME>\database (Windows).

Syntax: backup_dev_type = disk | tape | pipe | tape_auto | pipe_auto | 
                          tape_box | pipe_box | disk_copy | disk_standby | util_file | 
                          util_file_online | stage | stage_copy | stage_standby |
                          rman_prep | rman_util | rman_disk | rman_stage
disk: Database backups to disk.
The directory that should be used for the backups is defined in parameter backup_root_dir or archive_copy_dir.

See the following links for further help:

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/0d/d2f6b74a0c11d182b80000e829fbfe/frameset.htm">SAP Database Guide: Oracle (BC-DB-ORA-DBA)</a>

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/0d/d308f14a0c11d182b80000e829fbfe/frameset.htm">Initialization Profile init<DBSID>.sap</a>

Hope that helps,

Michael