how to change Tape to Disk for backup(via DB13) on MSSQL server

[Former Member]

Hello,

I have installed SAP- BW 3.5 on MSSQL database, windows 2003 OS.

Now i want to take backup from DB13 tcode, pls can any one guide me with steps to change the backup path --- as the default path it gives is "TAPE" while i want it to be "DISK"??

Also Transaction Log is incraesing a lot in my QAS server. I want to take backup and delete the old log file. Pls giude me with the steps to take transactional log backup and Free the space?

Pls help me.....

Regards,

Ankita

[Former Member · Accepted solution]

Hi,

configure backup devices on MS SQL Server management Studio,

logon to SQL server management Studio,

under object explorer navigate through server object -> backup devices

create new backup device -- destination file type.

regards,

kaushal

mark helpful answers

[Former Member]

Hi,

Make sure that R3DUMP0 is the device for the Tape backup. By default that is the where the tape is configured to. Please test it first. There is no need to create a new device since R3DUMP0 points to
.\tape0

Then when sceduling a backup thorugh DB13 just choose R3DUMP0.

I hope this helped.

Thanks,

Adil

Dont forget the points!