Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 How to re-define path restoring database?
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Posting Yak Master

108 Posts

Posted - 01/09/2013 :  23:50:00  Show Profile  Reply with Quote
I am using SQL Server 2012 Express (Management Studio).

I am trying to restore a database from a bak file to my database while is on hosting server.

First I connect to my hosting server using management studio.

Then when I try to restore the database from bak file which is on my computer. I select the database from "Device" - but when I click on "BROWSE" to locate the bak file - it is automatically using the path as - c:\Program files \ sql server \ MSSQL \ Backup

This path doesn't exists on my computer. Even though I try to create it manually, it still give me error that this path doesn;t exist.

How to change or re-define this default device file path ?

Very Important crosS Applying yaK Herder

52326 Posts

Posted - 01/10/2013 :  00:18:51  Show Profile  Reply with Quote
do you mean youcan navigate to path where you've bak file? or is it in another shared location?

SQL Server MVP

Go to Top of Page

Flowing Fount of Yak Knowledge

United Kingdom
3385 Posts

Posted - 01/10/2013 :  04:15:57  Show Profile  Visit nigelrivett's Homepage  Reply with Quote
>> First I connect to my hosting server using management studio.
>> when I try to restore the database from bak file which is on my computer

No hope unless you can share the folder on your machine to the hosted machine - and you probably should hope that is not possible.
You probably need to look at transfering the backup file to the server.

Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

Posting Yak Master

108 Posts

Posted - 01/10/2013 :  09:42:03  Show Profile  Reply with Quote
Sorry for the confusion but I think my question is something else..

When I try to restore from a .bak file to my new database - I am unable to do that because by default the sql server is choosing a path which doesn't even exist on my machine and I am not able to select a new path.

This is what I get I click on "Browse" button to select the .bak file from my computer

When I click on ok - I get the following (still no way to change the path to select .bak file):

Please help me

Edited by - asp__developer on 01/10/2013 09:42:38
Go to Top of Page

Flowing Fount of Yak Knowledge

7174 Posts

Posted - 01/11/2013 :  11:48:38  Show Profile  Reply with Quote
You need to copy the backup file if different server and then restore providing path.
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000