Backup to Virtual_Device

[skhanal]

Does anyone have any information backup to a virtual_device in SQL 2000?

We traced the sql lite speed and saw that it uses

BACKUP DATABASE dbname TO VIRTUAL_DEVICE ...

which is not documented in BOL. My search in google got me to few forum postings which were about people encountering error with virtual_device using third party backup tools such as ArcServer, Veritas Netbackup and CA BackStor.

[YuckFou]

I believe that VIRTUAL_DEVICE is normal backup device added with sp_addumpdevice
Check master.dbo.sysdevices for existence...
select * from master.dbo.sysdevices where name = 'VIRTUAL_DEVICE'

[skhanal]

No it's not.

I should have posted the complete syntax.

backup database "DB1" to VIRTUAL_DEVICE='VNBU0-580-5592'

If it was a dump device then syntax would have been

backup database "DB1" to VIRTUAL_DEVICE

[YuckFou]

In this way I found something here:
http://www.sql-server-performance.com/sql_2000.asp
http://www.sql-server-performance.co...ore_tuning.asp

look for Snapshot backup