且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

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

更新时间:2022-06-18 22:52:36

我认为不可能直接从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