使用Sql server在本地计算机上进行远程备份

本文介绍了使用Sql server在本地计算机上进行远程备份的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我想知道如何从远程sql server备份到本地机器。 如果有人知道plz让我知道。

Hi, I want to know how to take backup from remote sql server to Local Machine. If any one knows plz let me know.

推荐答案

我认为不可能直接从sql server备份到远程机器（在本例中是本地驱动器）因为sqlserver Backup对话框没有选择只选择网络驱动器的选项本地驱动器显示选择（SQL Server机器）所以在我的理解中你的任务无法直接完成。 I think it is impossible to take backup directly from sql server to remote machine (in this case to your local drive) because sqlserver Backup dialog box didn't give option to select network drive only Local drive display to select (SQL Server Machine) So in my understanding your task can't accomplish in direct way.

如果你仍然无法找不到合适的答案，我建议你仔细阅读这篇文章： 如何将远程SQL Server数据库备份到本地驱动器 你会在这里找到一些很好的见解主题，希望能解决你的问题 In case you still couldn't find the right answer, I suggest going through this post: How to backup remote SQL Server database to local drive There you'll find some great insights on this topic, and hopefully solve your problem