SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

asp__developer
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 ?

visakh16
Very Important crosS Applying yaK Herder

India
52317 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
http://visakhm.blogspot.com/

Go to Top of Page

nigelrivett
Flowing Fount of Yak Knowledge

United Kingdom
3383 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

asp__developer
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

sodeep
Flowing Fount of Yak Knowledge

USA
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  
 New 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.06 seconds. Powered By: Snitz Forums 2000