我的问题是直线前进,我怎么可以计划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.