Create Backup DB file that can be restored to different server

I have created a backup file of my SQL Server database on DiscountASP.Net. I am now attempting to restore that backup file to a local version of SQL server. The restore is failing. It appears as though it is referencing a file still located on the DiscountASP.Net servers. Any help would be welcome. I have been able to do this without problem from other hosting services. On the other servers I have used SQL Server Management Studio and created a backup using all of the defaults. any help would be welcome.

Steve

 

Nevermind ... figured it out.

 

Steve,

Please share the trick. I am having the same issue.

Thanks


Jpj

 

Using SQL Server Management Studio Express go to Tasks > Restore > Database and specify the Source as "From File" then locate your the backup file that you want to restore from. Click the Restore checkbox, then click Options. Click the Restore As (it is a directory path) and make sure that it is point to the local directory/filename on the local serverwhere you want the restore to be located.

This artical may help: http://msdn.microsoft.com/en-us/library/ms177429.aspx

Steve

 

Steve,

Thanks for the reply.

I came back because I want also to share what I found to solve my problem.

http://blogs.techrepublic.com.com/window-on-windows/?p=454


That's exactly the same as your instruction.


Jimi

 

How do you get the back up file (.bak)once you created the backup on the remote server. It shows a directory with D: drive and i can't seem to ship that back file to my local. any idia??

Regards