从远程数据库获取本地计算机中的备份文件 [英] get the back up file in the local machine from a remote database

问题描述

我执行了以下指示

I executed the following instruction

BACKUP DATABASE jpa TO DISK = 'G:\backJpa.bak'

在我的家用机器的SQL服务器管理工​​作室中通过本地网络连接到我公司的sql server。

请注意'G：\ backJpa.bak'引用我的机器中不存在于服务器中的路径。我希望使用sql命令将远程数据库的备份文件保存在我的本地计算机中。

我在尝试上述sql命令时得到的错误是：指定的路径是'n' t找到

In the SQL server management studio of my home machine which is connected via local network to the sql server of my company.
Note that 'G:\backJpa.bak' references the path that exists in my machine not in the server. i want that the back up file of the remote database to be saved in my local machine using the sql command.
the error i get when i tried the above sql command is : "the specified path isn't found"

推荐答案

找不到指定的路径

很清楚这个问题是提供路径。您尝试访问它然后备份的方式不起作用。



验证正确映射到给定路径的数据库的位置，然后验证保存它的路径是否可访问。

"the specified path isn't found"
It's pretty clear that the issue is with path provided. The way you are trying to access it and then backup is not working.

Verify the location of database being mapped correctly to the path given and then verify the path given for saving it is accessible.

您可以使用此工具来完全执行此操作： BAK to local [ ^ ]

You can use this tool to exactly do this: BAK to local[^]

这篇关于从远程数据库获取本地计算机中的备份文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！