Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
asp__developer
Posting Yak Master
108 Posts |
 Posted - 2013-01-09 : 23:50:00
|
| 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 \ BackupThis 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
52326 Posts |
Posted - 2013-01-10 : 00:18:51
|
| do you mean youcan navigate to path where you've bak file? or is it in another shared location?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2013-01-10 : 04:15:57
|
| >> First I connect to my hosting server using management studio.>> when I try to restore the database from bak file which is on my computerNo 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. |
|
|
|
asp__developer
Posting Yak Master
108 Posts |
Posted - 2013-01-10 : 09:42:03
|
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 |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2013-01-11 : 11:48:38
|
| You need to copy the backup file if different server and then restore providing path. |
|
|
|
|
|
|
How to re-define path restoring database?