Geek Answers Handbook

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

I wrote a program that backs up SQL databases using the SMO library on .net and everything goes smoothly, I just have the last point, I am changing the way to save the .bak file to my hard drive, from DeviceType.File to DeviceType.Pipe, I used the channels before, I just did not know how to implement it here.

+5
source share
2 answers

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

Out of sys.backup_devicespipe is outdated. Of course, I could be wrong, and I never used pipe backups (even back to my SQL Server 6.5 days)

Edit, OK found it ...

First entry here: Discontinued Database Engine Functionality in SQL Server 2005

Discontinued Function = Triggered Pipe Backup Devices

With the comment, "For security reasons, SQL Server does not support backing up named pipes."

So why is it still listed in DeviceType enumeration?

+6
source

The pipe is terminated. 100% confident

+1
source

More articles:


All Articles