SQL Server backup on disk from DB13 in 6.20

[Former Member]

Hello,

is it possible to perform database backups on disk (remote and local) in transaction DB13? Is the Enterprise Manager the only way to perform backups on disks?

The only media type available in DB13 is 'Tape' and I can't change this option (maybe there is no option). SAP Library provides confusing information, as it states that bakcup on disk is possible in DB13, but also points to the documentation of MS SQL Server in order to achieve it.

We have WAS 6.20 in 4.7 ES 1.10 with MS SQL Server 2000.

Thank you.

Antonio Sánchez.

[former_member185954 · Accepted solution]

I think there is something called as virtual devices in enterprise manager which can be configured as TAPE device.

This virtual TAPE could be a actual TAPE or a DISK.

Try configuring it and see if it is visible in DB13.

We had done this 2 years ago, don't remember it properly.

good luck.

regards,

siddhesh

[Former Member · Accepted solution]

Thank you Siddhesh,

as simple as

-> Management -> Backup -> New backup device ->

File Name. The device will be recognized as Disk device in DB13.

At the moment I have not tried the backup itself, but I guess (hopefully) this will work; anyway I think the question of this thread has been answered.

Thanks a million and best regards.

Antonio Sánchez.