Hi Guys,

I understand I should not post this here but thought of sharing as you guys might have experienced the same.

 I want to restore a SQL Server database from a .bak file generated from hosting provider (Arvix) to godaddy servers.

The approaches I tried are

1. Tried uploading to server repository using Backup Manager feature. After uploading it says invalid.bak file
2. Importing data - Indexes, stored procedures, Identity column does not retain in destination server tables
3. As Go-daddy support suggested, uploaded file using FileManager but now I don't know what to do next
4. Tried restoring DB using SQL Server Management Studio and selected .bak file stored in my local machine but it says No Restore         Backup file found.
5. Tried contacting pathetic support team. But they do not have any answer for this.

Any help guys?

Thanks AV

Thanks for the reply Joe.

As mentioned earlier I tried all the stuff as mentioned. But as there is dependency in GoDaddy none of the solution worked.

However I find out work around. 

a. Ran the generated scripts on GoDaddy Servers\.

b. Disable all FK constraints check.

c. Imported the data 

d. Re-enabled  constraints.

Worked fine.

Thanks once again.