using SMO .net to backup and restore through DeviceType.Pipe

Question

I wrote a Program that backup SQL Databases using SMO Library on .net , and everything is just going smoothly, I just have one last point, I'm changing my way to save the .bak file on the hard disk, from DeviceType.File to DeviceType.Pipe, I have used pipes before, I just didn't know how to implement it here .

Answer 1

I thought PIPE backup device was not available in SQL Server 2005 and above.

From sys.backup_devices, pipe is obsolete. I could be wrong of course, and I've never used pipe backups (even back to my SQL Server 6.5 days)

Edit, OK found it...

1st entry here: Discontinued Database Engine Functionality in SQL Server 2005

Discontinued feature = Named pipe backup devices

With comment "For security reasons, SQL Server does not support backup to named pipes."

So why is it still listed in the DeviceType enumeration?

Answer 2

Pipe is discontinued guys. 100% sure