SQL Server的SMO需要备份在本地的远程服务器 [英] SQL Server SMO take back up locally from remote server

问题描述

我的问题是直线前进，我怎么可以计划SQL SMO采取本地备份，通过连接到远程服务器。我想比克文件保存到被连接到远程服务器的本地计算机。此外，我希望用户只用特定的权限才能在本地保存备份。

My question is straight forward, how can I program SQL SMO to take local backup, by connecting to a remote server. I want to save the bak file to a local machine which is connecting to the remote server. Also I want users with only certain privilege to be able to save backups locally.

推荐答案

您不能 - 期。 SQL Server的备份可以的仅保存到本地磁盘 - 本地的SQL Server本身。

You cannot - period. Backups of SQL Server can only be saved to a local disk - local to the SQL Server itself.

您不可以有任何技巧或工具备份远程SQL Server到本地硬盘。只是不能做到这一点。

You cannot with any tricks or tools backup a remote SQL Server to your local harddisk. Just can't do it.

这篇关于SQL Server的SMO需要备份在本地的远程服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！