Trying to restore a local .BAK file to a remote SQL Server (on GoDaddy)

Question

0.00/5 (No votes)

See more:

SQL-Server-2012

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

Posted 22-Jul-15 9:28am

Charles T. Blankenship

Add a Solution

Comments

ZurdoDev 22-Jul-15 15:44pm

Correct, the bak file has to be accessible via the server.

[no name] 22-Jul-15 15:47pm

Would that not be an issue that you would need to take up with GoDaddy?

Charles T. Blankenship 22-Jul-15 15:59pm

Wes:

Hah hah! After the fifth call, I gave up ... hence my post here. As a matter of humorous interest, the guy that was helping me was reading posts from StackOverflow to me! I knew it was over right then and there.

Ryan:

I had a feeling that the answer to the question is "You can't ..." ... the only way I see to solve this is to migrate to a dedicated server. Or, parse the data into manageable query sizes, but then, referential integrity would make that a bit too complicated ... the records would have to insert in the proper parent-child order.

Oh well ... thanks for your time ...

CT

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard Deeming · Answer 1 · 2015-07-22T11:03:00

A Google search leads to this page:

Limitations to Restoring BAK Files[^]

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.