开发者

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

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 s开发者_运维百科ave 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 .


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?


Pipe is discontinued guys. 100% sure

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜