Create Backup DB file that can be restored to different server

Discussion in 'Databases' started by skaser, Oct 6, 2008.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. 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
     
  2. Nevermind ... figured it out.
     
  3. Steve,

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

    Thanks


    Jpj
     
  4. 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
     
  5. 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
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page