尝试将本地.BAK文件还原到远程SQL Server（在GoDaddy上） [英] Trying to restore a local .BAK file to a remote SQL Server (on GoDaddy)

问题描述

我一直在殴打这匹马太久了...我需要一些专业的帮助（读你）。



使用SQL Server Management Studio我可以成功连接到远程服务器并执行查询，通过执行从任务创建的脚本来创建数据库 - >生成脚本并选择数据库（仅限模式）...然后在远程计算机上运行该脚本（一切都很好）...这是给我问题的数据。



我遇到的问题是，当我尝试使用SQLSMS（任务 - >还原 - >还原数据库）还原远程服务器上的数据库时我指定文件的对话框位于远程数据库的上下文中...我无权访问文件系统以查找.BAK文件。当我继续并尝试进入文件的本地位置时，同样的问题引起了人们的注意。我无法将.BAK文件提供给远程服务器，我无法让远程服务器识别包含.BAK文件的本地文件系统。



因此，我很困难。



谢谢大家和女孩们，



CT

I've been beating this horse for too long now ... I need some professional help (read you).

Using SQL Server Management Studio I can successfully connect to the remote server and execute queries, create the database by executing the script created from Tasks -> Generate Scripts and selecting the database (Schema Only) ... then running that script on the remote machine (all good) ... it is the data that is giving me the problem.

The problem I'm having is that when I try to restore the database on the remote server using SQLSMS (Tasks -> Restore -> Restore Database) the dialog where I specify the file is in the context of the remote database ... where I do not have permission to access the file system to find the .BAK file. When I continue on and try to enter the local location of the file, the same problem raises its head. I cannot get the .BAK file to the remote server and I cannot get the remote server to recognize my local file system containing the .BAK file.

Hence, I'm oh so stuck.

Thanks guys and gals,

CT

推荐答案

谷歌搜索引导到这个页面：

A Google search leads to this page:

恢复BAK文件的限制 [ ^ ]

在主机控制面板中恢复SQL Server数据库备份文件时，您只能使用使用我们的主机控制面板中的备份功能创建的BAK文件。您无法恢复在我们系统外部创建的BAK文件。

When restoring a SQL Server database back-up file in the Hosting Control Panel, you are limited to using BAK files that you created using the back-up feature in our Hosting Control Panel. You are not able to restore a BAK file that was created outside of our system.

所以它看起来像你要做的就是'支持。

So it looks like what you're trying to do isn't supported.

这篇关于尝试将本地.BAK文件还原到远程SQL Server（在GoDaddy上）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！