使用Sql server在本地计算机上进行远程备份 [英] Remote Backup on local machine using 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

这篇关于使用Sql server在本地计算机上进行远程备份的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！